#1   Report Post  
Posted to microsoft.public.excel.misc
Jerry
 
Posts: n/a
Default Filters

Is there a way to limit the number of items in an autofilter dropdown list?
I am only interested in ascending, descending, top 10 and all. Don't want
the 1000 items that come up causing the ascending descending to disappear to
the top of the list.
--
Jerry
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Filters

I don't think so.

Jerry wrote:

Is there a way to limit the number of items in an autofilter dropdown list?
I am only interested in ascending, descending, top 10 and all. Don't want
the 1000 items that come up causing the ascending descending to disappear to
the top of the list.
--
Jerry


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filters in excel Crafty Carper Excel Worksheet Functions 2 February 8th 06 10:56 PM
Req: How to create multiple mutually exclusive filters six50joe Excel Worksheet Functions 2 September 26th 05 11:08 PM
filters logics abarwinski Excel Worksheet Functions 0 September 16th 05 11:53 AM
How to aviod reset of Pivot filters when reconnecting to database? Tonny Olesen Excel Discussion (Misc queries) 1 July 9th 05 01:26 AM
How can I protect an excel worksheet containing filters? JMcG Excel Discussion (Misc queries) 4 April 13th 05 03:13 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"