LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
sacwia01
 
Posts: n/a
Default Why does AutoFilter not show all the data in the pull down?

In an Excel spreadsheet with 12,000 lines, and autofilter on, all the
possible selections are not displayed in the filter pull down. I can use
custom filter in the pull down, but is more time consuming. I'd rather
scroll in the pull down. Is there a limit on the amount of lines shown in
the pull down? Or am I missing something?
 
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
Removing blank rows in a worksheet Louise Excel Worksheet Functions 6 May 26th 05 02:21 PM
Create view using data autofilter Arleigh Birchler Excel Discussion (Misc queries) 2 May 19th 05 07:42 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
using links to show data PHedges Excel Worksheet Functions 0 March 15th 05 03:37 PM
How do I get Data Analysis Plus tool pack in tools menu Show up. . epsilon8 Setting up and Configuration of Excel 1 February 11th 05 04:13 AM


All times are GMT +1. The time now is 07:03 AM.

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"