Autofilters-Remove (Top 10...) and (Custom) options from the drop-
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.
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 |
All times are GMT +1. The time now is 03:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com