ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Filer rows in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/171026-filer-rows-excel.html)

FFall

Filer rows in Excel
 
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

Filer rows in Excel
 
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


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com