limit autofilter drop down menu entries

P

purplec0ws

I am using an autofilter for a table with several columns in Excel 2003. How
can I limit what I want in my drop down menu entries. Autofilter
automatically populates the entries based on the values in the column. So
for example, if one of my menus has "sort ascending, sort descending, apples,
oranges" how can i take "apples" off the menu?
 
D

Dave Peterson

You can't change the way excel behaves.

Maybe you could use another column that eliminates the entries you don't want
and then filter by that column.
 

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

Placement of autofilter drop down menu? 6
Not sure where to turn for this information. 6
How to Sort within AutoFilter with Protection on (and AutoFilter . 1
Drop Down Menu Conditional Formatting 4
Drop Down choice needs to lead to another drop down menu 1
Cannot See Sort Ascending/Descding option in drop down filter 1
Sorting with AutoFilter 1
Index/match across multiple columns? 19

Top