You can't change the default items in the AutoFilter dropdown list.
Jen in SoCA wrote:
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
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html