Show All

L

lburg801

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

Thanks,
Trud
 
D

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.)
 
Top