+ Reply to Thread
Results 1 to 2 of 2

quick way to see which columns/s have filters set when given a huge spreadsheet?

  1. #1
    Registered User
    Join Date
    11-13-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    22

    quick way to see which columns/s have filters set when given a huge spreadsheet?

    Seems trivial but when I'm given a sheet with 100+ columns and one or more have active filters...is there an easy way to see which columns have these filters set?

    I need to do this in order to manipulate the data then give it back with the same filters set as they were when I received the file.

    thanks brains!

    Dave

  2. #2
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    400

    Re: quick way to see which columns/s have filters set when given a huge spreadsheet?

    can you attached sample file so all of us can see if we could help yiou

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can't open huge spreadsheet
    By johan_vrolijk in forum Excel General
    Replies: 10
    Last Post: 02-26-2013, 11:30 PM
  2. Excel 2007 : quick question with filters
    By blair9 in forum Excel General
    Replies: 3
    Last Post: 03-12-2012, 02:04 PM
  3. how to find autofilter columns in huge spreadsheet?
    By pleasehelpthanks in forum Excel General
    Replies: 1
    Last Post: 07-14-2011, 05:19 AM
  4. cannot scrol on huge spreadsheet - urgent
    By expres account in forum Excel General
    Replies: 2
    Last Post: 08-15-2006, 07:20 AM
  5. Replies: 2
    Last Post: 05-23-2006, 10:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1