Filtering Rows in Excel?
 

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

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

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


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

Alan Beban