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

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

Any thoughts

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