Autofilter

[Gail]

This was just working!

When I use "Autofilter", the filter function only works
for part of the spreadsheet. For example, I have names of
businesses-A thru Z. But when I use the down arrow of the
filter, it only lists business names A-C. Where is
everyone else? I haven't exceeded the '1000 unique items'
rule. What could be the problem?

 

[Bernie Deitrick]

Gail,

Do you have a blank line in your database, perhaps hidden?

HTH,
Bernie

 

[Joe]

Something else you can try is to higlight the data
section of your worksheet before using autofilter and
then select autofilter. I have found this to work with
different spreadsheets I use.

HTH
Joe