Autofilter

[George Gee]

Hi all.

I have a spreadsheet consisting of 2944 records.
Column F is a list of Hill names.

Using Autofilter, all the different hill names do not appear in the
drop-down box, when I click on the drop-down arrow for that column!

Is there a limit to the number of records / items that can be displayed,
or is there anything else that could be affecting this?

TIA

 

[Anders Silven]

Hi George,

This is a known issue. There are some answers here:

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

HTH
Anders Silven

 

[George Gee]

Anders

Brilliant! <g>

Many, many thanks!

George Gee


*Anders Silven* has posted this message: