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?
RE: Filtering
In "Data" menu, select "Filter", then "Show All"
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