Excel Shortcuts to Insert or Delete Rows and Columns

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on October 18, 2023

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 Rows

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

Add Columns

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 Rows

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:^+–

Delete Columns