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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Excel --> Word 4
Dates In Excel 5
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
auto filter on columns 2
Drop down lists in seperate columns 5
How to make repeating drop-down lists? 2
Drop down list control value in vba 2

Top