How do I expand a filter drop-down box?

  • Thread starter Thread starter vwest
  • Start date Start date
V

vwest

How do I expand a filter drop-down box from the 1000 entries allowed to fit
an entire range of cells?
 
You don't.

You work around the 1000 limit by using the "Custom" feature with "contains" and
"equal to" and "does not contain" and stuff like that.


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

extend the range of cells for a drop down list 8
Drop Down with dynamic named range offsheet source list 14
customize drop-down box 1
Date Range Drop Down Menu 1
in the drop down filter box how do you increase font size? 1
Formatted cell column in drop down list 1
count based on selection from drop down list 2
How do I create a drop down box within a drop down box? 1

Back
Top