Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all
Of course I know how to filter columns in Excel, but is there also a way to filter rows? I have not found this function in Office 2007. Is this possible at all? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Not really.
About the closest thing you can do is to select some columns and use Data|Group. I guess you could use View|Custom views to hide/show columns, too. Or even a macro that hides/shows columns. But all of those don't give the functionality of data|filter|autofilter. FFall wrote: Hi all Of course I know how to filter columns in Excel, but is there also a way to filter rows? I have not found this function in Office 2007. Is this possible at all? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
Filer dates | Excel Discussion (Misc queries) | |||
using filer command in excell it locks up my computer | Excel Worksheet Functions | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Filer within Pivot Table | Excel Discussion (Misc queries) |