Shortcut Key for Data-Filter-Show All?
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 |
Shortcut Key for Data-Filter-Show All?
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.) Andrew wrote: 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 -- Dave Peterson |
Shortcut Key for Data-Filter-Show All?
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_Fil..._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" wrote in message ... 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 |
Shortcut Key for Data-Filter-Show All?
Thanks David.
Andrew "David McRitchie" wrote: 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_Fil..._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" wrote in message ... 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 |
Shortcut Key for Data-Filter-Show All?
Thanks. Dave. I didn't even thing about looking in the Commands tab on the
customize window. I like that. Thanks, Andrew "Dave Peterson" wrote: 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.) Andrew wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 11:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com