1

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?

1
  • Doesn't the button Clear on the Data tab this job for you?
    – Ben Welman
    Feb 26, 2013 at 16:39

2 Answers 2

3

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

1
  • Glad it helped @ccanitano67! Would you be so kind as to accept the answer?
    – Gary
    Apr 12, 2013 at 12:54
2

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!

You must log in to answer this question.

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