Shortcut key to 'Clear All'

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

Hello, I often use Home tab-->Clear-->ClearAll (Edit-->ClearAll in 2003)

Is there a keyboard shortcut for it?

I'd find that VERY handy

Thanks

M
 
How about adding an icon to your favorite toolbar?

If that's ok...

Tools|Customize (just to see that dialog)
Now select Edit|Clear (on the toolbar)
And ctrl-click (that's important!) and drag the All icon to your favorite
toolbar.

If you ctrl-click (you'll see a box with a + near it), you'll be copying the All
Icon.

If you just drag, then you'll be moving it!

Now rightclick on that All icon on your favorite toolbar.

Change the Name to something you like: Clear All

And close that customize dialog box.
 
Try one, simple, macro command:
Cells.Clear
and attach it to some shortcut and or a command-bar button.
If you want to use it in each and every WB - place it inside persona.XLS
Micky
 
Back
Top