Results 1 to 3 of 3

Thread: Filtering Rows

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Is Excel capable of filtering rows like it filters columns?

  2. #2
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Please don't quote me on this as I may be wrong:

    I don't beleive that Excel has any built in functionality for doing that. However, you could write code to achieve this?

  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
    Do you mean " Is Excel capable of filtering COLUMNS like it filters ROWS"

    Autofilter allows filtering of rows of particular columns. There is no builtin way to filter columns. You can transpose the data and then filter on rows....

    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
  •