The quickest shortcut to insert a row in Excel

The fastest way to add a row in Excel depends on where you want it. If you want a new row above the row your cursor is on, right-click that row number on the left side and select Insert from the menu. On Windows, you can also select the row and press Ctrl + Plus (the plus key on your keyboard). On Mac, select the row and press Ctrl + Shift + Plus. Excel will open a small dialog asking what you want to shift — choose Entire row and click OK.

The keyboard shortcut is faster than the menu if you insert rows often, because your hands stay on the keyboard. The right-click menu is faster if you insert rows rarely, because you do not have to remember which keys to press.

Key Takeaways

  • On Windows, select a row and press Ctrl + Plus to insert a new row above it; on Mac, press Ctrl + Shift + Plus.
  • Right-clicking the row number and selecting Insert works on both Windows and Mac and opens a dialog to confirm what shifts.
  • You can select multiple row numbers at once and insert that many rows in a single action.
  • The new row appears above whichever row you selected, not below it — select the row below where you want the new one to go.

How to insert a single row using the keyboard

Click on the row number on the left side of the spreadsheet to select the entire row. The row will highlight in blue. Then press Ctrl + Plus on Windows or Ctrl + Shift + Plus on Mac. A dialog box will appear with the heading Insert.

The dialog shows two options: Entire row and Entire column. Entire row is already selected. Click OK and Excel will insert a blank row above the row you selected. Everything that was in that row and below it shifts down one row.

How to insert multiple rows at once

If you need to add three rows, do not insert them one at a time. Instead, click on the first row number, then hold Shift and click on the third row number. This selects three consecutive rows, all highlighted in blue. Now press Ctrl + Plus (Windows) or Ctrl + Shift + Plus (Mac).

Excel will insert three new blank rows above the first row you selected. This is much faster than inserting one row three times. If the rows you want to select are not next to each other, hold Ctrl and click each row number separately, then use the same keyboard shortcut.

Using the right-click menu instead

Right-click on any row number on the left side. A menu will appear with several options. Click Insert. The same dialog box appears as with the keyboard shortcut, with Entire row already selected. Click OK to insert the row.

This method works identically on Windows and Mac, so if you switch between computers or work with people who use different operating systems, the right-click method is the same everywhere. It also works if you forget the keyboard shortcut.

Why the new row appears above, not below

Excel always inserts the new row above whichever row you selected. This confuses people at first, because they select the row where they want the new data and expect the new row to appear below it. Instead, the new row appears above it.

The way to think about it: you are telling Excel "insert a row here," and "here" means at the position of the row you selected. If you want a new row below row 5, select row 6 and insert. The new row will be row 6, and what was row 6 becomes row 7.

Inserting a row in the middle of data

Click on the row number where you want the new row to appear. For example, if you have data in rows 1 through 10 and you want to add a new row between row 5 and row 6, click on row 6. Press Ctrl + Plus (Windows) or Ctrl + Shift + Plus (Mac), then click OK. A blank row now sits between your old row 5 and your old row 6.

All the data that was in row 6 and below has shifted down one row. Formulas that refer to specific row numbers will update automatically — if a formula referred to row 7, it now refers to row 8. This is why inserting rows in the middle of a spreadsheet usually does not break your calculations.

Frequently Asked Questions

Can I undo inserting a row if I made a mistake?

Yes. Press Ctrl + Z on Windows or Cmd + Z on Mac immediately after inserting the row. Excel will remove the row and move everything back to where it was. You can undo multiple times if you inserted several rows.

What is the difference between inserting a row and just typing in an empty row?

Inserting a row shifts everything below it down, so you do not overwrite data that was already there. If you just click an empty cell and type, you might be typing over data you did not see. Inserting is the safe way to add space in the middle of existing data.

Does the keyboard shortcut work the same way in Google Sheets?

No. Google Sheets uses different shortcuts. Right-click a row number and select Insert 1 above or Insert 1 below. There is no single keyboard shortcut for inserting rows in Google Sheets the way there is in Excel.

What if I select a row by clicking a cell instead of the row number?

The shortcut still works, but it inserts a row above the row that cell is in. Clicking the row number is clearer because you can see the entire row highlighted, so you know exactly which row will be affected.