30 Advanced Excel Tips for 2026

Excel Champs / Excel Keyboard Shortcuts / Insert – Add Row(s) – (Excel Shortcut)
By Puneet Gogia (Microsoft MVP)

Insert – Add Row(s) – (Excel Shortcut)

Click any cell in the row that should sit directly below the new row, press Shift + Space to select the whole row, then press Ctrl + Shift + +. Excel inserts a blank row above your selection.

To insert several rows at once, select that many rows first (for three, press Shift + Space, then Shift + ↓ twice) and press Ctrl + Shift + +. You get the same number of blank rows above the selection.

If only a cell is selected, Ctrl + Shift + + opens the Insert dialog instead; choose Entire row and press Enter. On a full-size keyboard, Ctrl + + on the numeric keypad works the same way.

To insert a row without selecting it first, use the key tips Alt, H, I, R (Home → Insert → Insert Sheet Rows) or the older menu sequence Alt, I, R, pressing the keys one after another. Press F4 or Ctrl + Y to repeat the insert (Fn + F4 on some laptops).

A sheet row runs across every column, so it also splits any data sitting beside your list. If your list is an Excel Table, right-click a cell in it and choose Insert → Table Rows Above to add a row inside the table only.

If Excel says it cannot shift nonblank cells off the worksheet, something sits in the last row of the sheet, usually stray data or formatting. Press Ctrl + End to find the real end of the used range, delete the unused rows below your data, save, and try again.

Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)

Inserting or Adding a row in Excel is an easy task if you know the shortcut. Many times, while working in Excel, users want to add blank row(s) and they can add it very quickly using keyboard shortcuts instead of going to the “Insert” icon under the “Home” tab.

Keyboard Shortcut to Insert a New Row in the Excel

Alt → I → R

Ctrl + Shift + +

Steps to Add Row(s) Using Keyboard Shortcut

1. Using the Keyboard Shortcut Alt → I → R

  1. First, click on any cell within the row above to which you want to add the new blank row.
    click-on-the-cell
  2. After that, simply press “Alt → I → R” and you will get the new row inserted above the selected cell.
    added-new-row

2. Using keyboard shortcut Ctrl + Shift + Plus Sign (+)

  1. First, select the row using the keyboard shortcut “Shift + Spacebar” above which you want to add the new blank row.
    select-the-row
  2. After that, press shortcut keys “Ctrl + Shift + Plus Sign (+) and you will get the new blank row inserted above your selected row.
    press-shortcut-to-add-row

Points to Remember

  1. Excel always adds the row(s) above the selected row or cell, we cannot change this default setting.
  2. Once you added a row, you can just press the “Fn+F4” keys for Excel to repeat the task to add more blank rows.
  3. In case, you have multiple data sets in the same sheet, convert the data set to a table because Excel inserts the row starting from column A to the end of columns in the sheet unless you have the data in the table, which can mess up the other data set.

Leave a Comment