ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Viewing drop down box for a filter (https://www.excelbanter.com/excel-discussion-misc-queries/204465-viewing-drop-down-box-filter.html)

B

Viewing drop down box for a filter
 
Is it possible to permantly expand the drop-down box for a filter so that I
do not have to scroll each time I use that filter?

Dave Peterson

Viewing drop down box for a filter
 
I don't think so.

But maybe you can use some of the techniques at Debra Dalgleish's site so that
it's less scrolling:
http://contextures.com/xlautofilter02.html#Limits



B wrote:

Is it possible to permantly expand the drop-down box for a filter so that I
do not have to scroll each time I use that filter?


--

Dave Peterson

B

Viewing drop down box for a filter
 
Thanks for the tip.

"Dave Peterson" wrote:

I don't think so.

But maybe you can use some of the techniques at Debra Dalgleish's site so that
it's less scrolling:
http://contextures.com/xlautofilter02.html#Limits



B wrote:

Is it possible to permantly expand the drop-down box for a filter so that I
do not have to scroll each time I use that filter?


--

Dave Peterson



All times are GMT +1. The time now is 06:39 AM.

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