data in rows not showing in auto-filter drop down

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

Work sheet is only about 150 rows. Rows that appear in auto-filter are random.
 
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
 
You must log in or register to reply here.

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

auto filter on columns 2
auto-filter image 3
Auto Filter - It's broken! Help! (Office '03) 2
Data Filter drop down 3
Hidden Rows with Auto-Filter 2
Auto Filter Comma Dilemiation 2
Dependent drop down dynamic range formula, off sheet. 7
hidden rows problem 7

Back
Top