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

Font drop-down menu very slow 0
How to make repeating drop-down lists? 2
Link a text box based on drop down box with four options MS Word 365 0
Using "sort" in auto filter not possible when protected? 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Create own tool bar Mac 2015 0
Drop down list control value in vba 2
Placement of autofilter drop down menu? 3

Top