View Single Post
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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