Excel Tips: Add a New Row with a Shortcut

Lesson 15: Add a New Row with a Shortcut


Add a new row with a shortcut

Sometimes you may want to add a blank row to your spreadsheet. Luckily, there is an easy keyboard shortcut for this: Ctrl+Shift+Plus. Simply click a row number to select a row, hold down the Ctrl and Shift keys, and press plus (+). Excel will then add a row above the selected row.

Watch the video below to see this shortcut in action.