Autofilters-Remove (Top 10...) and (Custom) options from the drop-

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, sorry if this is a stupid question, but can't find any help on this.
Would like to remove the default filtering options (top 10...) and (Custom)
from the drop-down menu in an autofilter. Anybody know how to do this?
Using Excel 2000.

Thxs-

Jen
 
You can't change the default items in the AutoFilter dropdown list.
 
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

Filter by Top 10 doesn't work 1
How do I get rid of "Top 10" and "Custom" choices Autofilter? 2
Autofilter not capturing all cells 2
Excel 2002 Autofilter 1
drop down list 1
filter data by top 10 AND bottom 10 items simultaneously 4
autofilter - custom... 2
Custom AutoFilter 4

Back
Top