Rows Excel Shortcut: Insert, Delete, and Select Rows

In Excel for Microsoft 365 on Windows, select a whole row and press Ctrl+Shift+Plus to insert a new row above it. If you select cells instead of a full row, the same shortcut opens the Insert dialog, where you can choose Entire row.

The quickest way to insert a row

Excel inserts worksheet rows above the selected row, not below it. To use the shortcut, click a cell in the row that should move down, select the entire row, and then press the insert shortcut. You can select the row with the mouse by clicking its number at the left edge of the worksheet, or use the keyboard:

Click a cell in the row where the new row should go.
Press Shift+Space to select the entire worksheet row.
Press Ctrl+Shift+Plus to insert a row above the selection.

On most US keyboards, the plus sign shares the equals key, so the keystroke is made by holding Ctrl and Shift while pressing =. Excel documentation and keyboard layouts may display this as Ctrl+Shift+= or as Ctrl+Shift+Plus. The key combination is the same on a typical US layout. Other layouts may place the plus sign elsewhere, so use the key that produces plus on your keyboard.

If you have clicked the row number first, Excel already has the full row selected; you do not need the extra Shift+Space step. The new blank row appears above the selected one, and the existing row contents move down. This does not overwrite the data that was already in the selected row.

Why the row is inserted above

Excel’s insert command works by adding space at the selection. A selected row provides a clear boundary, so Excel places the new row above it and shifts the selected row and the rows below it downward. For example, if row 8 is selected, inserting a row creates a blank row 8; the old row 8 becomes row 9.

This is useful when adding a new record in the right position in a list. To add a record after the current last row, select the row immediately below the list, then insert. If the list ends at row 25, selecting row 26 and inserting creates a blank row at 26. Typing into the first empty row may be quicker when there is already unused worksheet space, but inserting is appropriate when existing data must move down.

A common misconception is that Excel has a separate one-key shortcut to insert a row below the active cell. The standard insert shortcut inserts above a selected row. To get a new row after a particular record, select the row beneath that record before using the shortcut.

Insert several rows at once

You can add multiple adjacent rows in one operation. Select the same number of existing worksheet rows as the number of blank rows you want, then use the insert shortcut. For example, to add four rows above row 10, select rows 10 through 13 by dragging across their row headers or by selecting a cell in row 10 and extending the selection through row 13. Press Ctrl+Shift+Plus. Excel inserts four rows above the selection, shifting the original rows 10 through 13 down.

For a keyboard-only selection, click a cell in the first target row, press Shift+Space to select that row, and extend the selection downward with Shift+Down Arrow as needed. Check the highlighted row numbers before inserting. Selecting five rows and using Insert adds five rows; it does not matter whether the selected rows contain data or are blank.

Adding rows in a block is generally faster and reduces the chance of inserting the wrong number through repeated commands. If you need rows in separate parts of a sheet, insert each block at its intended location and recheck formulas, references, and totals afterward.

Other ways to insert worksheet rows

The keyboard shortcut is not the only option, and the ribbon or context menu can be easier to discover when you are learning Excel:

Ribbon: Select a row, then choose Home > Insert > Insert Sheet Rows.
Context menu: Right-click the row number and choose Insert.
Keyboard selection: Select a cell in the target row, press Shift+Space, then use the insert shortcut.

When only one or more cells are selected, rather than whole rows, the shortcut opens the Insert dialog. Choose Entire row and confirm. The dialog also offers options for shifting cells, which is why selecting full row headers first is the more predictable approach when you intend to add worksheet rows.

The ribbon command is a useful fallback if a keyboard layout makes the plus key awkward or another application intercepts the shortcut. It performs the same kind of worksheet-row insertion when the selection is a full row.

Selecting and deleting rows

Row selection is useful beyond insertion. Press Shift+Space while a cell is active to select its entire row. To select adjacent rows, keep the first row selected and extend the selection with the arrow keys while holding Shift, or drag over the row numbers. Press Ctrl+Space to select an entire column.

To delete rather than insert, select the full row and press Ctrl+Minus on Windows. If you select only cells, Excel may show a Delete dialog so you can choose whether to shift cells or delete the entire row. The ribbon alternative is Home > Delete > Delete Sheet Rows. Deleting a row removes its contents and shifts the rows underneath upward; it is different from pressing the keyboard’s Delete key, which normally clears cell contents without removing the worksheet row.

Use deletion carefully in structured data. Removing a row can change ranges, references, charts, and totals. If the goal is only to make the cells look empty, clear their contents rather than deleting the whole row. If you delete by mistake, Ctrl+Z usually undoes the action, provided you have not performed an operation that clears the undo history.

Rows in Excel tables

Excel tables have their own structure, so a worksheet row and a table row are related but not identical. When you insert a worksheet row through the row header where a table sits, the table commonly expands to include the new space. If you want to add a record specifically within a table, right-click a cell in the table and look for the table-row insertion option in the context menu, such as Insert > Table Rows Above. The exact available command depends on where the selected cell is in relation to the table.

At the bottom of a table, pressing Tab from its final cell can create a new table row, which is convenient for entering the next record. Tables also automatically carry formatting and calculated-column formulas into added rows in many typical cases. Still, check the resulting table boundaries and formulas if the table is near other data; Excel cannot always infer that nearby cells should belong to the table.

For a plain worksheet range that has not been formatted as a table, the usual full-row selection and insert shortcut is the straightforward choice. Converting a range to a table is not required just to insert rows.

Common shortcut problems

If the shortcut does not behave as expected, check what is selected and which key your keyboard is sending. These are the usual causes:

The Insert dialog appears: You selected cells rather than the row header. Choose Entire row, or press Esc, select the full row with Shift+Space, and try again.
A row was added in the wrong place: Excel inserts above the selected row. Select the row below the position where you want the blank row.
The plus key is hard to press: On a US layout, hold Ctrl and Shift and press the equals key. On other keyboard layouts, locate the key that types plus, or use the ribbon command.
The command is unavailable: The worksheet may be protected, or the workbook may have restrictions on inserting rows. Check Review > Protect Sheet and the workbook’s permissions; do not assume the shortcut is broken.
Excel reports that it cannot shift cells: Content or formatting near the bottom or right edge of a sheet can prevent cells from moving. Inspect the worksheet’s used area and remove genuinely unnecessary content or formatting before trying again.

Also distinguish the plus shortcut from the separate number-pad plus key. Keyboards differ, and a laptop may not have a dedicated numeric keypad. The ribbon route is a reliable alternative when the physical key combination is unclear. In a shared workbook or a sheet with formulas, consider whether inserting a row will affect other users or calculations before making the change.

Windows, Mac, and Excel for the web

This guidance is for Excel for Microsoft 365 on Windows. On a Mac, select the row and use Control+Shift+= to insert; keyboard layouts can affect how the plus key is entered. If that combination does not work on your Mac, use the ribbon command Home > Insert > Insert Sheet Rows or the row-header context menu. Mac keyboards and Excel settings can vary, so the menu is a useful way to confirm the intended operation.

In Excel for the web, keyboard shortcuts can be affected by the browser and its own shortcut assignments. The row-header context menu or the ribbon’s insert command is the dependable fallback. Microsoft updates the web app over time, and available commands can vary with the interface, but the underlying rule remains: select the row where new space should begin, and insert above it.

If you are following instructions for an older Excel release, the basic Windows row-insertion shortcut has been consistent across many desktop versions. However, ribbon labels and web behavior can differ. When helping someone using another operating system, give the menu route as well as the shortcut so the steps remain usable.

Frequently Asked Questions

What is the shortcut to insert a row in Excel?
On Windows, select the full row and press Ctrl+Shift+Plus. On a typical US keyboard, this means holding Ctrl and Shift and pressing the equals key. Excel inserts a blank row above the selected row.

How do I insert a row without a mouse?
Click a cell in the target row, press Shift+Space to select the full row, then press Ctrl+Shift+Plus. The new row appears above the selected row.

How do I insert multiple rows in Excel?
Select as many full rows as you want to add, starting at the position where the new block should begin, and use the insert shortcut once. Selecting three rows inserts three blank rows above the first selected row.

Does Excel insert a row above or below?
It inserts above the selected row. To place a new row below a record, select the row immediately beneath that record before inserting.

What is the shortcut to delete a row?
Select the entire row and press Ctrl+Minus on Windows. This removes the row and shifts rows below it upward. Pressing the Delete key alone generally clears cell contents rather than deleting the worksheet row.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.