Filters for rows instead of columns

[Hall]

The filter feature works great for columns.

Can it be used for rows?

 

[Gord Dibben]

No.

You can sort across a row, but not filter.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Not as nice, but maybe you could use:
Data|Group and Outline|Group

To show/hide columns.

 

[Max]

well, guess you could also try transposing the source table in another sheet
then use autofilter in the normal way in that sheet if its meaningful

one quick way to transpose ..

Assume source table is within A1:E10 in Sheet1 (10R x 5C),
with A1:E1 as col headers, and possibly A2:A10 as row headers

In Sheet2,
Put in A1: =OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)
Copy across by 10 cols to J1, fill down to J5 (ie fill out a 10C x 5R range)
then apply autofilter to the 10 col headers in A1:J1

 

[Max]

Try also Andrew Engwirda's page at:
http://blog.livedoor.jp/andrewe/archives/50283818.html
with a d/l link for a sample file on the page
(Horizontal Filter)

 

[Dave Peterson]

Or
Edit|copy the range
select a new cell outside that range
edit|Paste special|click Transpose.

or
select a range on that new sheet (reversing the number of columns and rows) and
in the topleft cell, type:

=transpose(

then back to the other sheet and select the original range
and hit ctrl-enter to fill the current selection with that transposed data