+ Reply to Thread
Results 1 to 3 of 3

Invert selected filters - column headers

  1. #1
    Registered User
    Join Date
    11-24-2009
    Location
    Hull, England
    MS-Off Ver
    Excel 2003, 2007
    Posts
    32

    Invert selected filters - column headers

    If I have a huge data set and have filtered out all of the data I don't want to see, is there a way I can switch between the two easily? I'll move the unwanted to a new sheet.

    Can filter selections be saved and applied to several sheets?

  2. #2
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465

    Re: Invert selected filters - column headers

    Hi,

    Please try Custom Auto Filter option.
    I think this should be help you.


    Rahul
    __________________
    Regards
    Rahul Nagar
    Founder of www.myshortcutkeys.com.


    If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
    Also
    If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

  3. #3
    Registered User
    Join Date
    11-24-2009
    Location
    Hull, England
    MS-Off Ver
    Excel 2003, 2007
    Posts
    32

    Re: Invert selected filters - column headers

    Hi thanks very much. By chance I just found this and custom text filtering 'Contains' "XYZ" is very useful.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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