You could Transpose to Columns.
If you have fewer than 256 rows to filter in this manner, you could:
Copy the range to filter.
Go to a new sheet.
Edit | Paste Special | Transpose
Then, you will have Columns instead of rows, and you can use the AutoFilter.
tj
"Peter W" wrote:
Hi
I have a colleague who wishes to filter across a row and not a column.
As I understand it the filter functions on Excel are specific to columns.
Any suggestions appreciated.
Peter
|