My Favorite Insert, Delete, And Select Shortcuts In #Excel

Here are some of my favorite keyboard shortcuts for selecting data, inserting columns and rows, and deleting columns and rows.

Selecting a data range:

Both of these options begin with positioning your cursor in the upper left corner of the range and require that there are no empty rows or columns in your range.

Option 1) Ctrl + Shift + right cursor arrow, then down cursor arrow.

Option 2) Ctrl + * (asterisk on number keypad). The alternative is Ctrl + Shift + 8.

Inserting a row:

All these options begin with positioning your cursor in the row or column where you want it added.

Option 1) Alt H I R (hit the Alt key then the H, I, and R keys in succession.)

Option 2) Ctrl + + (plus sign on the number keypad – the alternate is Ctrl + Shift + =). Then hit the down arrow once to select “Entire row” and hit Enter.

Inserting a column:

All these options begin with positioning your cursor in the row or column where you want it added.

Option 1) Alt H I C (hit the Alt key then the H, I, and C keys in succession.)

Option 2) Ctrl + + (plus sign on the number keypad – the alternate is Ctrl + Shift + =). Then hit the down arrow twice to select “Entire column” and hit Enter.

Deleting a row:

All these options begin with positioning your cursor in the row or column where you want it added.

Option 1) Alt H D R (hit the Alt key then the H, D, and R keys in succession.)

Option 2) Ctrl + – (minus sign on the number keypad or number row). Then hit the down arrow once to select “Entire row” and hit Enter.

Deleting a column:

All these options begin with positioning your cursor in the row or column where you want it added.

Option 1) Alt H D C (hit the Alt key then the H, D, and C keys in succession.)

Option 2) Ctrl + – (minus sign on the number keypad or number row). Then hit the down arrow twice to select “Entire column” and hit Enter.

Happy Excelling!

Related Post

Free Download!

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

, , , , , ,

No comments yet.

Leave a Reply