tiny tip! Ctrl+Plus sign to insert rows in Excel

To quickly insert a new row or column in Excel:

  1. Select the row below where you want a new row to appear, or the column to the right
  2. Type Ctrl+plus sign

To delete a row or column:

  1. Select the row or column
  2. Type Ctrl+minus sign (or the hyphen)

If you accidentally insert or delete a row or column, type Ctrl+Z right away--that's the keyboard shortcut for Undo!