Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Doesn't the button Clear on the Data tab this job for you? – Ben Welman Feb 26 '13 at 16:39

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.

quick access toolbar customise excel 2010

share|improve this answer
Thanks Gary! That is exactly what I was looking for!! – CCanitano67 Apr 2 '13 at 15:15
Glad it helped @ccanitano67! Would you be so kind as to accept the answer? – Gary Apr 12 '13 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!

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .