Filtering Rows in Excel?

[Guest]

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

 

[Guest]

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

 

[Alan Beban]

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

He might want to consider the functions in the freely downloadable file
at http://home.pacbell.net/beban, particularly the ArrayColumnFilter
function.

Alan Beban