When I use Auto Filter the drop down list is blank

C

CAF

I have a spreadsheet that I have be using for years. Now, when I use Auto
Filter and go to the drop down lists, the lists are blank; meaning a list
existings, just can see the listed items. If I click in the blank field,it
selects as if I can see it but I'm guessing from a blank list. It is almost
like the text in the list is "white" and therfore blank.
I tried turning Auto Filter off and then selecting the range and turning
Auto Filter back on but it doesn't help.

The problem exists on multiple sheets in the workbook but not ALL sheets.
I'm very confused.
 

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

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Drop down lists in seperate columns 5
Set as Default Template not working 0
Filtered drop down list 2
Help with drop down selection and populating related data... 9
Auto filter on blank lines 1
Auto-filter not grabbing all the data 2

Top