Autofilter Is Missing Some Entries

  • Thread starter Thread starter Mae
  • Start date Start date
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?
 
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 **
 
Ah ha! Yes, I'm sure I have over 1000. I never knew it
was limited, thanks for the quit response.
 
Back
Top