Is it possible Autofilter Rows ?

[wwgmr]

I am wondering if it is possible to use excel to autofilter Rows instead of Columns the way it works by default? I have a table that because it uses times I want to sort the number of columns I show by a rows value. Just like you would using Autofilter, but I don't see a way to do this in Office 2000? Is it possible? Thanks!

 

[SkipVought]

Hi,

Are you saying that you have ROWS of common data as you normally would have COLUMNS of common data???

Filters work on a column of data by hiding rows that fail to meet that column's criteria. There is no such feature for hiding columns of data that fail to meet a row's criteria.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[wwgmr]

I have a table that I made with columns as headings in the first row. I transposed it to another sheet to be able to read it with more space showing rather then scrolling across. Its just that before I used autofilter to allow me to choose days of the week to view. It would only show the rows that had Say M in that column. Now that I have transposed that table I can no longer autofilter that column as it is now a row.

Example before I had column c Each record (rows) had either a M or it was blank. Now instead of it being column C its row 3. My records are listed by column each column being a record. So if I only want to show the columns that have a M in row 3 I can't use the autofilter as it works with rows being the records.

I believe that is a Yes to your question. I will have a row that I am looking for common data in to filter by.

Thanks

 

[xlbo]

can't be done I'm afraid - code would be the only option - loop through the columns and hide those which don't meet the criteria

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[GPOTony]

>I transposed it to another sheet to be able to read it with more space showing rather then scrolling across.

For filtering, the column headings have to be in a row, not in a column. You can do this, and have the room you want, as follows:

Enter the full Column Headings in a row.
Select the row.
Increase the Row Height to, say, 50.
Format Cells..Alignment. Set the Orientation to 90. This displays the headings Vertically.
Format..Column..AutoFit Selection, which narrows the width of the column to the width of the heading.
You will then be able to AutoFilter by column.

Hope this helps.

 

[wwgmr]

Thanks all, I didn't think it would be easy fix. Just would have been nice. What I am going to end up doing is linking the cell to equal value on a different sheet then have that sheet filter in the normal method.

Thanks again for all the help.

 

[GPOTony]

Hi,
Did you try my suggestion? It worked for me.

 

[wwgmr]

Thanks Tony, what my filter would be doing is taking one row to filter. a1 would have say company. Then in column b1 would be first company column c1 would be another company. What i then wanted to do was click on a1 and sort the companys to the right of it. The same way as you can using Autosort Feature. Which goes Down instead of across. I don't believe its do able with any ease.

Thanks anyway. I just made columns closer and used buttons to Hide columns that I don't need while viewing. It works almost as well.