Show All

[lburg801]

No shortcut key is displayed for "Show All", and I use it so often. Is there a way to create one's own shortcout? I was wondering about a macro, but don't want to do something that might create problems.

Thanks,
Trudy

[Dave Peterson]

Tools|Customize|commands tab
data category
Look for the "Show all" button and drag it to your favorite toolbar.

(I've dragged the autofilter button right next to it, too.)



lburg801 wrote:
>
> No shortcut key is displayed for "Show All", and I use it so often. Is
> there a way to create one's own shortcout? I was wondering about a
> macro, but don't want to do something that might create problems.
>
> Thanks,
> Trudy
>
> --
> lburg801
> ------------------------------------------------------------------------
> lburg801's Profile: http://www.excelforum.com/member.php...o&userid=28338
> View this thread: http://www.excelforum.com/showthread...hreadid=480269

--

Dave Peterson

[lburg801]

Thanks Dave! I now have them both on my favorite toolbar.