In Excel 2003, I had a shortcut on the taskbar for "show all". When I clicked on this button, all the filtered items would open up. Can someone help me find this shortcut on Excel 2010 so I can add it to the Quick Access Toolbar?
2 Answers
This feature has moved to the Data tab of the Excel Ribbon. To add this to the Quick Access Toolbar:
- Click the drop-down arrow on the end of the Quick Access Toolbar
- Choose More Commands
- Under Choose Commands from select Data Click Clear in the list and press Add Press OK to see this button located on the Quick Access Toolbar.
-
Glad it helped @ccanitano67! Would you be so kind as to accept the answer?– GaryApr 12, 2013 at 12:54
I usually use the old Excel 2003 shortcut: Alt D F S (for Data->Filter->Show all)
Alternatively, pressing Ctrl-Shift-L will add/remove an AutoFilter. Thus, pressing it twice will reset/clear it, too!