98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - filter
Excel - filter
Resolved · Low Priority · Version 2010
Antje has attended:
Upgrade to Office 2010 course
Excel - filter
Hi,
I'm just in the process of customizing my Quick Access Toolbar in Excel and would like to add the command that could be found under Data/Filter/Show all in 2003. Where can I find this in 2010, please? I have looked under All Commands, but no luck.
Many thanks.
RE: Excel - filter
Hi Antje, thanks for your query and welcome to the forum. If you're trying to add the "remove filter" option to the Quick Access toolbar, you'll might find it's been renamed. In the Customise box, change from Popular Commands to "Data Tab". Scroll down the list until you find Clear and add that cross to the right hand pane. That should remove any filters from tables that have an autofilter switched on.
Hope this helps,
Anthony
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move or Highlight CellsUse any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move. |