Insert One Row Above in Excel: Shortcut and Methods

In Excel for Microsoft 365 on Windows, select the row where the new row should go, then press Ctrl+Shift++ (Ctrl, Shift, and the plus key). Excel inserts a blank worksheet row above the selected row. If your keyboard makes the plus sign with the equals key, press Ctrl+Shift+=.

The Windows Shortcut and What It Does

The shortcut inserts a whole row when an entire worksheet row is selected. It does not place the new row above the active cell alone: Excel adds it above the selected row across the worksheet, from column A through the last available column. Existing rows below move down, and formulas and references may adjust as Excel updates the sheet.

To use it from a cell, first select the full row that should move down. Click that row’s number along the left edge of the worksheet, or select a cell in the row and press Shift+Space. Then use Ctrl+Shift++. For example, to add a blank row above row 8, select row 8 and press the shortcut. The new row becomes row 8, and the former row 8 shifts to row 9.

On many standard Windows keyboards, the plus sign shares the equals key, so producing + requires Shift. That is why the same keystroke is often written as Ctrl+Shift+=. On a keyboard with a separate numeric keypad plus key, the physical keys can differ; the intended command is Excel’s Insert Rows command. If the shortcut opens a dialog instead of inserting a full row, check that the row header—not just a single cell—is selected.

Select the Correct Row First

The selection determines what Excel inserts. A selection of a complete worksheet row tells Excel to insert a complete row above it. A selection of one or more cells instead may open the Insert dialog, where you choose how cells should shift. This distinction is the main reason the shortcut can seem inconsistent.

Click any cell in the row that should move down, such as A8.
Press Shift+Space to select the entire worksheet row. If Excel is in cell-editing mode, press Esc first, or finish the edit before selecting.
Press Ctrl+Shift++ (or Ctrl+Shift+= on a keyboard where plus is typed with Shift and equals).

You can also click the row number directly. A highlighted row header confirms that the whole row is selected. If only a cell outline is visible, Excel has not selected the complete row. To select several neighboring rows, drag over their row numbers or select one row and extend the selection with Shift-click on another row header.

Insert Several Rows Above at Once

To insert more than one row in a single action, select the same number of existing rows as the number of blank rows you need, then use the shortcut. Excel inserts that many rows above the first selected row. For instance, selecting rows 8 through 10 and pressing the insert shortcut adds three blank rows above row 8; the selected data moves down together.

This is often quicker and less error-prone than repeating the shortcut. Before doing it, make sure the selection contains the intended number of complete rows. If you accidentally select rows 8 through 11 when you only need three, Excel will insert four. You can undo the insertion immediately with Ctrl+Z, then select the correct number and try again.

For rows that are not next to one another, use separate insert actions. Excel does not treat a discontiguous selection as one continuous block of rows to insert in a predictable way. Insert a block above the first location, then repeat at the other locations, checking each insertion point as you go.

Use the Ribbon or Row-Header Menu

If you prefer not to use a keyboard shortcut, select the target row and choose Home > Insert > Insert Sheet Rows. This inserts a worksheet row above the selected row. The command is useful when the keyboard layout is unfamiliar or when you want to confirm that Excel is inserting a sheet row rather than shifting a small group of cells.

A mouse alternative is to right-click the selected row number and choose Insert. Right-clicking the row header makes the selection context clear: the command applies to the complete worksheet row. By contrast, right-clicking a cell displays options that may apply only to cells or to a table, depending on where the cell is located.

Ribbon labels can vary slightly with the Excel window size or interface version, but the Insert menu is on the Home tab. If the ribbon is collapsed, expand it or use the row-header menu instead. Both methods produce the same basic result when a worksheet row is selected.

Worksheet Rows, Cells, and Excel Tables

A worksheet row and a row inside an Excel table are related but not always interchangeable. A worksheet-row insertion adds a row across the entire sheet. This is appropriate when the data is an ordinary range or when the new space must extend across multiple columns of a worksheet.

If the active cell is inside a formatted Excel table and you only want to add a record to that table, use the table-specific command instead. Right-click a table cell in the row where the new record belongs, choose Insert, then choose Table Rows Above when that option is available. This adds a table row without asking you to shift a small selection of cells. Table commands and labels can depend on where you right-click, so check that the menu explicitly refers to table rows.

A common misconception is that pressing the row-insertion shortcut while a cell in a table is selected must add only a table row. The result depends on the selection and command Excel invokes. If you need to preserve the table’s boundaries and calculated-column behavior, use the table-specific option or click the first cell below the table and press Tab to extend the table with a new row. If you intend to create space across the sheet, select the worksheet row header and insert a sheet row.

What Happens to Data, Formulas, and Formatting?

When Excel inserts a complete row, it shifts existing content below the insertion point downward rather than overwriting it. Formulas that refer to moved cells commonly update their references to continue pointing to the corresponding data. However, formulas, named ranges, external links, charts, and structured table references can behave differently depending on how they were created, so review important calculations after a structural change.

The new row often inherits formatting from nearby rows. Excel may show an Insert Options button near the inserted area, allowing you to choose formatting such as matching the row above or below, or clearing formatting where that option is offered. If the inserted row looks different from its neighbors, inspect the cell formatting and the Insert Options choices rather than assuming the shortcut failed.

In a worksheet with filters, hidden rows, merged cells, or a carefully arranged print layout, inserting a row can change what is visible or how the sheet prints. The row is still inserted in the worksheet structure, but it may not appear where expected if a filter hides records or if the view is scrolled. Clear or inspect filters and check the row numbers around the insertion point.

Common Shortcut Problems

A dialog appears: You probably selected a cell or cell range rather than the row header. Select the full row with Shift+Space or click its number, then try again.
Nothing seems to happen: Confirm that Excel, rather than another window, has focus. Also check whether the keyboard’s plus key requires Shift or whether a laptop function layer changes the key behavior.
The wrong number of rows appears: The number of selected row headers determines how many rows Excel inserts. Undo with Ctrl+Z and reselect the intended count.
The new row appears in an unexpected place: Check the highlighted row number, filters, hidden rows, and the current scroll position. A row is inserted above the selected row, not necessarily above the first visible record.
The menu offers table options: You may be inside a formatted table. Choose the table-row command if you want to expand only the table; select a worksheet row header if you specifically need a full sheet row.

For a workbook with important formulas or a complex layout, save before making a large batch of structural edits. Ctrl+Z can undo a recent insertion, but it may not be available after closing the workbook or after performing other actions that replace the undo history.

Mac and Excel for the Web

In Excel for Mac, the key combination is generally Control+Shift+= to enter the plus sign, with a complete row selected first. Keyboard layouts differ, so if that combination is awkward or does not work, click the row number and use the ribbon command Home > Insert > Insert Sheet Rows. The ribbon method avoids uncertainty about which physical key produces the plus sign.

In Excel for the web, browser and keyboard-layout differences can affect shortcut behavior. The dependable method is to select the row number, then use the Home tab’s Insert command or right-click the row header and choose Insert. The inserted row goes above the selected row. If a browser intercepts a shortcut or the command menu looks different, the row-header method is a practical alternative.

Frequently Asked Questions

What is the shortcut to insert a row above in Excel?
On Windows, select the complete row and press Ctrl+Shift++ (often typed as Ctrl+Shift+=). Excel inserts a blank row above the selected row.

Can I insert a row above without selecting the whole row?
Yes. Select a cell and use Home > Insert > Insert Sheet Rows, or right-click the row number and choose Insert. For the keyboard shortcut, selecting the full row first makes the intended action clear.

How do I insert multiple rows above in Excel?
Select the same number of complete rows as the number you want to add, then run the insert command once. Excel inserts that count above the first selected row.

Why does Ctrl+Shift++ open an Insert dialog?
Excel may be treating your selection as a cell or range rather than a complete row. Select the row header or press Shift+Space from a cell in the target row, then repeat the shortcut.

Does inserting a row above work the same way in an Excel table?
Not always. To add a record within a table, use the table-specific Insert > Table Rows Above command. To add a full worksheet row, select the worksheet row header and insert a sheet 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.