Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.