there are no filters that work that way.

You could probably write code that hides columns based on some criteria you
pass to the code.

--
Regards,
Tom Ogilvy

"parenson " wrote in message
...
Is it possible to filter columns in Excel rather than filter rows? When
you do an AutoFilter and select a value in a column, Excel will filter
out the rows that do not match the selected filter criteria. I need to
turn this 90 degrees and specify a value in a row and then have the
columns filtered out accordingly.

I have attempted transposing my spreadsheet to turn columns into rows
and rows into columns, but this screws up the formatting.

Any thoughts?


---
Message posted from http://www.ExcelForum.com/