ExcelBanter - Auto Filter Not Displaying all results

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Auto Filter Not Displaying all results (https://www.excelbanter.com/excel-discussion-misc-queries/125737-auto-filter-not-displaying-all-results.html)

Excel novice

Auto Filter Not Displaying all results

It appears as if Auto Filter limits the number of items in the drop down box
- is that correct and is there any way to increase the number of items?

Ron Coderre

Auto Filter Not Displaying all results

See Debra Dalgleish's website for options:

http://www.contextures.com/xlautofilter02.html#Limits

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"Excel Novice" wrote:

It appears as if Auto Filter limits the number of items in the drop down box
- is that correct and is there any way to increase the number of items?

All times are GMT +1. The time now is 01:51 PM.