Excel Shortcuts to Insert or Delete Rows and Columns

This tutorial will demonstrate the shortcuts to add or delete row(s) and column(s) in Excel.

Shortcut to Add/Delete Rows/Columns

Add Rows

To add row(s):

1. Select the row below where you’d like to insert.
   1. Click on the Row number to select the entire row.
   2. Hold down SHIFT to select multiple rows. This will insert multiple rows.
2. Use this shortcut:
   PC Shortcut:Ctrl++
   Mac Shortcut:^+I

Add Columns

To add column(s):

1. Select the column after where you’d like to insert.
   1. Click on the Column letter to select the entire column.
   2. Hold down SHIFT to select multiple columns in order to insert multiple columns.
2. Use this shortcut:
   PC Shortcut:Ctrl++
   Mac Shortcut:^+I

Delete Rows

To delete row(s)

1. Select the Row you’d like to delete.
   1. Click on the Row number to select the entire row.
   2. Hold down SHIFT to select multiple rows for deletion.
2. Use this shortcut:
   PC Shortcut:Ctrl+–
   Mac Shortcut:^+–

Delete Columns

1. Select Column you’d like to delete.
   1. Click on the Column letter to select the entire column.
   2. Hold down SHIFT to select multiple columns for deletion.
2. Use this shortcut:
   PC Shortcut:Ctrl+–
   Mac Shortcut:^+–