Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2002
    Posts
    33
    Thanks
    2
    Thanked 0 Times in 0 Posts
    In Excel 2003 (WinXP Pro, SP3), when I select Data, Filter, the "Show All" selection is greyed out. Is there some other criteria that must be used to get "Show All" to function? Something needs to be turned ON or activated.

    Screen shot attached.

    Thanks,
    Attached Images Attached Images

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hello - Try performing a Data>Filter>AutoFilter
    Then after the filtering, Show All will be available.

    Tim

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Show all is "greyed out"/ not available when the data has no autofilter or the data (with an autofilter) has not been filtered.


    Steve

Posting Permissions

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