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