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.