Filtering Rows in Excel?

P

Peter W

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
 
T

tjtjjtjt

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
 
A

Alan Beban

Peter said:
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
Click to expand...
He might want to consider the functions in the freely downloadable file
at http://home.pacbell.net/beban, particularly the ArrayColumnFilter
function.

Alan Beban
 
Top