Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filter on the rows
Is there any possibility to make a filter on the rows? -- shlomop ------------------------------------------------------------------------ shlomop's Profile: http://www.excelforum.com/member.php...fo&userid=9734 View this thread: http://www.excelforum.com/showthread...hreadid=467093 |
#2
|
|||
|
|||
As far as I know, no. Filters can only be applied to columns. You may need to transpose your data to apply a filter. I'm sure if someone knows of a way (probably via VBA) they will post a solution. Good Luck Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=467093 |
#3
|
|||
|
|||
Not really.
But you could play around with Grouping your columns. You'll see those same kind of +/-'s but at the top. Select a few columns data|Group and Outline Group (but it's a manual effort--well, unless you came up with rules and make a macro out of it.) shlomop wrote: Is there any possibility to make a filter on the rows? -- shlomop ------------------------------------------------------------------------ shlomop's Profile: http://www.excelforum.com/member.php...fo&userid=9734 View this thread: http://www.excelforum.com/showthread...hreadid=467093 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit the number of rows for a filter | Excel Discussion (Misc queries) | |||
Find the number of rows returned in a filter | Excel Discussion (Misc queries) | |||
how can i filter from two rows? | Excel Discussion (Misc queries) | |||
Can I set a filter for a merged column across multiple rows and o. | Excel Worksheet Functions | |||
Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions |