Clear Content Shortcut or VBA script?

General advanced Excel topics and questions to make your life easier and to increase your productivity and efficiency countlessly.

Moderators: wstexpert, wsthost

Clear Content Shortcut or VBA script?

Postby nicakin » Wed Jun 06, 2012 9:32 pm

I wonder if there is any shortcut key for the "clear content" function. If not, is there any VBA script that I can use to make it an add-in?
Posts: 2
Joined: Fri Nov 11, 2011 10:25 pm

Re: Clear Content Shortcut or VBA script?

Postby wsthost » Thu Jun 07, 2012 6:57 pm

We use the old Excel 2003 menu keystrokes:
Alt+E+A+A which is Edit, Clear, All

We also use
Alt+E+A+F which is Edit, Clear, Formatting

We considered creating a macro in our WST macros but decided against it since we were running out of keystrokes and would have to use a Ctrl+Shift+Alt+[letter] which doesn't provide any keystrokes savings since Ctrl+[letter], Ctrl+Shift+[letter] was mostly used up. we are reserving the remaining unused Ctrl+Alt+[letter] keystrokes for functions that don't pre-exist in Excel's menus.

In Excel 2007/2010, you can do:
Alt+H+E+A and Alt+H+E+F which is the same 4 keystrokes.
Site Admin
Posts: 456
Joined: Thu Jul 24, 2003 5:53 pm

Return to Excel Topics

Who is online

Users browsing this forum: No registered users and 1 guest