Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut key to 'Clear All'
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut key to 'Clear All'
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. Michelle wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut key to 'Clear All'
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 "Michelle" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to 'Replace all' | Excel Discussion (Misc queries) | |||
XL2002 - Disable 'clear all' when protected | Excel Discussion (Misc queries) | |||
How do I use 'Find All' and copy the entire row | Excel Discussion (Misc queries) | |||
pivot table duplicates numbers under 'drop down show all'? | Excel Discussion (Misc queries) | |||
How do I insert a 'clear all' button in excel? | Excel Worksheet Functions |