H
Hall
The filter feature works great for columns.
Can it be used for rows?
Can it be used for rows?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
No.
You can sort across a row, but not filter.
Gord Dibben MS Excel MVP
You can sort across a row, but not filter.
Gord Dibben MS Excel MVP
D
Dave Peterson
Not as nice, but maybe you could use:
Data|Group and Outline|Group
To show/hide columns.
Data|Group and Outline|Group
To show/hide columns.
M
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
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
M
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)
http://blog.livedoor.jp/andrewe/archives/50283818.html
with a d/l link for a sample file on the page
(Horizontal Filter)
D
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
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