Autofilter

  • Thread starter Thread starter Gail
  • Start date Start date
G

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?
 
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
 
Back
Top