data in rows not showing in auto-filter drop down

G

Gary''s Student

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.
 
G

Gord Dibben

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
 
Top