Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2003
    Thanked 0 Times in 0 Posts

    Auto Filter (any)

    I very often use the auto filter to hide certain rows in my worksheets, but is there a way to do the same with columns? Thanks.


  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts

    Re: Auto Filter (any)

    No there is no built-in way. The closest is to "Group/Outline" by columns, but I do not think this is what you want. You can hide/unhide columns depending on how they are grouped, but it does not work like autofilter on individual rows to fileter columns like an autofilter would.

    Some options:
    Create your own code to check the columns and then hide them (could be very cumbersome)

    Redesign the database to more conventional: fields as the columns, data in rows. and then use the conventional filtering:
    Transpose your database so the columns are rows and rows are columns
    Other redesign options.

    If you want to provide some details of your current design and how you plan on using the data (inputting desires and output needs) we can offer some suggestions.


Posting Permissions

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