| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter by Rows??
All of the information needed to filter is in columns vs. rows. I want to
filter a very large spreadsheet by row and not by column, is it possible?? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter by Rows??
Try this work around, select you all your data, once you have everything
selected, copy it (ctrl+c) then go to a new worksheet and make a right click on the A1 cell, then select Paste Special and then Transpose. You will be able to apply filters then. hope this work for you! "erriac" wrote: All of the information needed to filter is in columns vs. rows. I want to filter a very large spreadsheet by row and not by column, is it possible?? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter by Rows??
Hi
Take a look at the following example form Debra Dalgleish http://www.contextures.com/AdvFilterStateNum.zip -- Regards Roger Govier "erriac" wrote in message ... All of the information needed to filter is in columns vs. rows. I want to filter a very large spreadsheet by row and not by column, is it possible?? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the maximum filter for rows? | Excel Discussion (Misc queries) | |||
| Filter columns instead of rows | Excel Discussion (Misc queries) | |||
| Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
| filter on the rows | Excel Discussion (Misc queries) | |||
| how can i filter from two rows? | Excel Discussion (Misc queries) | |||
Hybrid Mode
