Autofilter Is Missing Some Entries

M

Mae

I have Autofilter turned on, and one of the columns is
Check#. The column is formatted as text. Some of my
check numbers do not appear in the list when I click on
the Autofilter arrow-button. There are no leading spaces
or invisible characters in the cells. I can't figure out
why they don't show up... Any suggestions?
 
P

Paul B

Mae, the AutoFilter is limited to 1000 entries, do you have more than that?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
M

Mae

Ah ha! Yes, I'm sure I have over 1000. I never knew it
was limited, thanks for the quit response.
 
Top