Limit on filter drop-down list?

[koltregaskes]

Hello,

Is there a limit (in any Excel version, including 2003) on the amount
of items that can be listed in the dropdown menu on a filter?

For example, if I create a column with numbers 1 to 2000 (in rows 1 to
2000) and auto-filter it, if I click on the drop down it only shows
down to 1000.

Is this the case and if so is there a workaround?

K

 

[Roger Govier]

Hi

There is a limit of 1000 on displayed values from a dropdown.
Debra Dalgleish has some workarounds at
http://www.contextures.com/xlfaqFun.html#AutoFilter

Regards

Roger Govier