Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba excel - Filtering
|
|
|
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. |
vba excel - Filtering
Resolved · Low Priority · Version Standard
Reply Fri 20 Apr 2007, 09:26Delegate David said...
David has attended:
Excel Intermediate course
Excel Advanced course
Filtering
If I have filtered many of the columns, how do I quickly take all the filters off so that all the information on the worksheet can be displayed.
Hope you can help?
For upcoming training course dates see: Pricing & availability
Reply Fri 20 Apr 2007, 10:26Delegate Tom said...
RE: Filtering
In "Data" menu, select "Filter", then "Show All"
Reply Fri 20 Apr 2007, 10:30Delegate David said...
RE: Filtering
Thanks, I thought it would be something simple.
RE: Filtering
Hi David,
Thanks for the question,
The quickest way to take all the filtering off would be to go into the Data menu and go down to Filter and across to the option that says AutoFilter. Alternatively, you could also put this up on your toolbar as a shortcut so instead of using the menus you can use the buttons. If you want help on how you would go about that let me know
Hope that helps
Tracy
Reply Fri 20 Apr 2007, 10:33Delegate David said...
RE: Filtering
Thanks for your help.
|