The Insert and delete rows guide
Select the row with Shift+Space, then press Ctrl+Shift+= (that is, Ctrl++) to insert a row above it, or Ctrl+- to delete it. On a Mac, Microsoft lists ⌃⇧= to insert and ⌘- to delete.
Select the row first
With a whole row selected, the shortcuts insert or delete the row straight away. With just a cell selected, Excel opens a small dialog asking whether to shift the cells down, right, up or left, or take the entire row. Shifting cells moves part of a row and leaves the rest behind, which is how a value ends up next to the wrong month. Shift+Space first avoids the question.
What happens to formulas
- A row inserted inside a range makes the range grow:
SUM(B2:B10)becomesSUM(B2:B11). - A row inserted just below the range, above the total, is outside it. Type a number there and the total ignores it.
- Deleting a row inside a range makes it shrink. A formula that pointed at a deleted cell shows
#REF!.
Several rows at once
Select three rows (Shift+Space, then Shift+↓ twice) and the insert shortcut adds three rows. The same goes for deleting. Home → Insert → Insert Sheet Rows and Home → Delete → Delete Sheet Rows do it from the ribbon.
Common mistakes
- Deleting the contents, not the row. Delete empties the cells and leaves a blank row behind, which then breaks filters and Ctrl+arrow jumps.
- Inserting in the wrong place. The new row goes above the selected one.
Shift+Space has its own lesson: whole rows and columns.
FAQ
- What is the shortcut to insert a row in Excel?
- Select the row with Shift+Space, then press Ctrl+Shift+= (Ctrl and the + key). On a Mac, Microsoft lists Control+Shift+=.
- What is the shortcut to delete a row in Excel?
- Select the row with Shift+Space, then press Ctrl+- (minus). On a Mac it is Command+- or Control+-.
- Why does Excel ask me to shift cells when I insert?
- Only a cell was selected, not the whole row. Press Shift+Space first, or choose Entire row in the dialog.
- Does my SUM update when I insert a row?
- Yes, if the new row is inside the summed range. A row added just below the range, above the total, isn't included.



































































