Shortcut Key for Data-Filter-Show All?

A

Andrew

Is there a one stroke short-cut key to show all data if a filter is applied.
I know I can create a macro and assign a short-cut key to it and I know I can
do an Alt-D-F-S but was just wondering if there was already an existing
shortcut.

If there's not, no big deal, I'll manage.

Thanks,
Andrew
 
D

Dave Peterson

How about an alternative...

You can add an icon to your favorite toolbar.

Tools|Customize|commands tab|data category.
look for Show All and drag it to a toolbar.

(I've also added the autofilter "funnel" icon right next to it.)
 
D

David McRitchie

A

Andrew

Thanks David.

Andrew

David McRitchie said:
I don't see any shortcut in my list derived from HELP
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

the following is the same as Dave Peterson's but one step further , the extra
step may or may not work for you depending on your menus..

The following might work for you it involves installing a custom builtin button
and then using Alt+S
Quick Filtering Using the AutoFilter Icon
http://www.exceltip.com/st/Quick_Filtering_Using_the_AutoFilter_Icon/251.html

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Andrew said:
Is there a one stroke short-cut key to show all data if a filter is applied.
I know I can create a macro and assign a short-cut key to it and I know I can
do an Alt-D-F-S but was just wondering if there was already an existing
shortcut.

If there's not, no big deal, I'll manage.

Thanks,
Andrew
Click to expand...
Click to expand...
 
A

Andrew

Thanks. Dave. I didn't even thing about looking in the Commands tab on the
customize window. I like that.

Thanks,
Andrew
 
Top