Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - filter
|
|
|
The UK's most regular 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 - filter
Resolved · Low Priority · Version 2010
Reply Fri 13 May 2011, 09:50Delegate Antje said...
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.
For upcoming training course dates see: Pricing & availability
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
|