Excel Tips
Add a New Row with a Shortcut

Back to Tutorial

Lesson 15: Add a New Row with a Shortcut

/en/excel-tips/absolute-references-with-the-f4-key/content/

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.

/en/excel-tips/use-an-entire-column-as-a-cell-range/content/