Three Keyboard Shortcuts To Clear All In #Excel

Here are three keyboard shortcuts you can use to clear all the data and formatting from a data range in Excel:

Here are three keyboard shortcuts you can use to clear all including data, formatting, comments, etc. from a data range:

Ctrl + Home – This will take you to the upper left corner of your worksheet
Ctrl + Shift + Right Arrow – this will highlight the top row of your data range. While still holding the Ctrl + Shift keys, hit the Down Arrow – this will highlight the whole data range area.
Alt H E A – Hit the Alt key then H E A. This is the same as clicking on the Clear All button from the Clear drop down menu in the Editing group of the Home tab. Alt activates the ribbon shortcut keys, H selects the Home tab, E selects the Clear drop down menu, and A selects Clear All.

Doing all those in quick succession will clear everything from your data range.

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , ,

2 Responses to Three Keyboard Shortcuts To Clear All In #Excel

  1. Jens Stolle November 27, 2013 at 1:11 pm #

    Hello Michael,

    I like your tips, try to read them all and sometimes I find something I didnt know. You can select the complete table by hitting CTRL-A twice. That followed by ALT H E A as you suggested does the Job too and is easier to remember 🙂

    Cheers!

    • Michael Rempel November 27, 2013 at 1:26 pm #

      Thanks, Jens. Agreed, when you want to remove from the entire sheet, Ctrl + A twice fills the bill. My focus was on a small data range, but your tip is a good reminder, too. Glad you like the tips!

Leave a Reply