Filters for rows instead of columns


H

Hall

The filter feature works great for columns.

Can it be used for rows?
 
Ad

Advertisements

G

Gord Dibben

No.

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.
 
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
 
Ad

Advertisements

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top