data in rows not showing in auto-filter drop down

  • Thread starter Thread starter Denise
  • Start date Start date
Sometimes blanks and other "junk" will cause the autofilter to fail.

Don't just click on the header cell when you set the autofilter, select the
entire table.
 
Only unique data will appear in the AF dropdown.

Data will appear in ascending order either numerically or alphabetically.

Numerics will show at top of mixed list of data.

Blanks will not show in the dropdown.

What do you see and why do you say "random"?


Gord Dibben MS Excel MVP
 
Back
Top