ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   (auto)filter on row (https://www.excelbanter.com/excel-programming/393403-auto-filter-row.html)

Bogdan

(auto)filter on row
 
Is there any posibility to create an autofilter on row (instead of columns)?

Many thanks,

Bogdan

Dave Peterson

(auto)filter on row
 
Not quite the same, but you can group columns.

Select a few columns
(in xl2003)
data|Group and outline|Group



Bogdan wrote:

Is there any posibility to create an autofilter on row (instead of columns)?

Many thanks,

Bogdan


--

Dave Peterson

Dave Peterson

(auto)filter on row
 
You may want to define different views, too.

In xl2003, hide the columns you want.
View|custom views|add (a new view)

Include a view that unhides everything to make it easy.

===
Another option would be to use a macro to hide columns that you don't want to
see.

Dave Peterson wrote:

Not quite the same, but you can group columns.

Select a few columns
(in xl2003)
data|Group and outline|Group

Bogdan wrote:

Is there any posibility to create an autofilter on row (instead of columns)?

Many thanks,

Bogdan


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 07:08 PM.

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