View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
purplec0ws purplec0ws is offline
external usenet poster
 
Posts: 7
Default limit autofilter drop down menu entries

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?