Excel Hotkey to Add a Row: Shortcuts and Tips

In Excel for Microsoft 365 on Windows, select a row by clicking its number, then press Ctrl+Shift++ to insert a blank row above it. On many keyboards, the plus sign requires pressing Shift+=, so the shortcut is often typed as Ctrl+Shift+=. If you select only a cell, Excel may show an Insert dialog instead; choose Entire row there.

The Windows shortcut and what it does

The insert shortcut adds space at the selected position; it does not simply write a blank line into the sheet. When a whole worksheet row is selected, Excel inserts a new worksheet row above that selection and shifts existing rows down. The contents, formulas, formatting, and other cell details below the insertion point move with the cells.

There is a small but important keyboard distinction: the shortcut is described as Ctrl plus the plus sign, not Ctrl plus the ordinary equals sign. On a standard US keyboard, plus shares the key with equals, so you hold Ctrl and Shift while pressing that key. Some keyboards have a dedicated plus key or a numeric keypad plus key, so the exact key combination can vary. If the shortcut does not work as expected, use the row-selection steps below or the ribbon command.

Excel inserts the row above the selected row. For example, if row 8 is selected, the new blank row becomes row 8, and the old row 8 and everything below it move down one position. This is why selecting the row beneath the desired insertion point is a reliable way to control where the new space appears.

Select the right thing before pressing the shortcut

What Excel inserts depends on the selection. Clicking a row number at the left edge of the worksheet selects the entire row, which is usually the simplest setup for adding one row. You can also click a cell in the target row and press Shift+Space to select its full worksheet row. Then use the insert shortcut.

If you select just one cell and press the insert shortcut, Excel may open the Insert dialog because it needs to know whether to shift cells right, shift cells down, insert an entire row, or insert an entire column. Choose Entire row and confirm. Inserting a row is different from shifting a few cells: a whole-row insertion affects every column in the worksheet, including columns far to the right of the data you can currently see.

Before using the shortcut, check that Excel is not actively editing a cell. If the cursor is inside the cell text or formula bar, press Esc to cancel editing or Enter to commit the edit. Then select the row. Otherwise, the keystrokes may be entered into the cell rather than interpreted as a command.

Step-by-step: add one blank row

Find the row number where the new row should appear. To put a row between rows 7 and 8, select row 8.
Click the row number 8, or click a cell in row 8 and press Shift+Space.
Press Ctrl+Shift++ (often entered as Ctrl+Shift+= on a US keyboard).
Confirm that the new blank row has appeared above the selected row and that the existing data moved down as intended.

This method is useful for inserting a row in the middle of a dataset without overwriting existing information. For instance, if a list of monthly orders has one row per order and a missing order needs to be recorded between two existing entries, select the lower order’s row and insert. Then enter the missing record in the newly blank row.

Be aware that insertion can affect formulas and references. Excel typically adjusts references when rows are inserted, but the exact outcome depends on how a formula is written and where the insertion occurs. After adding a row in a calculation-heavy workbook, inspect totals, charts, and linked reports rather than assuming every dependent item changed in the way you intended.

Insert several rows at once

You do not have to repeat the shortcut for every new row. Select the same number of existing worksheet rows as the number of blank rows you want, then insert. For example, to add three rows above row 10, select row headers 10 through 12 and use the insert shortcut. Excel creates three blank rows above the first selected row.

To select adjacent rows with the mouse, click the first row number and drag down across the other row numbers. With the keyboard, select a cell in the first target row, press Shift+Space to select the row, and extend the selection to adjoining rows with Shift+Down Arrow. Check the highlighted row numbers before inserting: Excel uses the size of the selected block to determine how many rows to add.

Inserting a block is usually quicker and less error-prone than inserting rows one at a time, especially when a prepared form or report needs several empty entries. The rows are inserted together above the first row in the selected block. If you need rows at different, unrelated locations, insert each group at its own location; a single continuous selection cannot create separate groups in different parts of the sheet.

Adding rows inside an Excel table

An Excel table is a structured data range with features such as filter buttons and automatically extending formatting. When your active cell is inside a table, inserting a row may add a table row rather than behaving like an ordinary worksheet insertion. The new row becomes part of the table, which is generally what you want when adding another record.

You can use the shortcut while a table row is selected, but check the result: the added line should retain the table’s banding or other table formatting, and the table’s filter controls should still apply to the full data range. If the shortcut produces a dialog or the result is not what you intended, right-click a cell in the table and use the Insert options to add a table row above. The wording of available commands can depend on whether you right-click a table cell, a table row, or a worksheet row header.

Another convenient method is to move to the last cell in the last table row and press Tab. Excel adds a new table row when you press Tab from that position, allowing you to continue entering records at the bottom. This is not the same as inserting a row in the middle: use the row-insert shortcut or the table’s Insert command when the new record belongs between existing records.

Ribbon and Mac alternatives

If you prefer not to use a keyboard shortcut on Windows, select a worksheet row and choose Home > Insert > Insert Sheet Rows. This command inserts a full worksheet row above the selection. Using the row-number header first helps ensure that Excel inserts a row rather than opening options for shifting individual cells.

Excel for Mac has similar row-insertion options, but keyboard behavior can depend on the Mac keyboard layout and the keyboard settings. The insert command is commonly entered with Control+Shift+= when the plus sign requires Shift; if that combination is intercepted or does not match your keyboard, use the ribbon’s Home > Insert command or the context menu after selecting a row. On a Mac, do not assume that replacing Ctrl with Command will produce the Windows shortcut; Excel’s shortcuts are not all simple Command-key substitutions.

Excel for the web runs in a browser, where some keyboard shortcuts can overlap with browser commands or vary with the operating system. Selecting the row and choosing the Insert command from the Home ribbon is a dependable alternative if the shortcut behaves differently. The key principle is the same across versions: select the row position first, then insert a sheet row above it.

Common shortcut problems and fixes

The Insert dialog opens. You likely selected a cell rather than the whole row. Choose Entire row, or close the dialog and select the row number before trying again.
Nothing happens. Check whether you are editing a cell, whether the worksheet is protected, and whether your keyboard produces the plus sign with Shift. Try selecting a row header and using the ribbon command.
A column or cells are inserted instead. Review the selection and the Insert dialog choice. A single cell selection can prompt Excel to shift cells rather than insert a complete row.
The new row appears in the wrong place. Excel inserts above the selected row. Select the row immediately below the intended location.
The row is added but does not look like the rest of the data. Check whether the range is an Excel table or an ordinary cell range. Table rows inherit table behavior; a normal range may require copying formatting or using a consistent row format.

A protected worksheet may prevent row insertion, depending on the protection settings. If the command is disabled, you may need permission to unprotect the sheet or to change its allowed actions. In a shared or controlled workbook, do not remove protection without checking with the workbook owner, because protection may preserve important structure or formulas.

How row insertion differs from clearing or overwriting

Inserting a row creates new space and moves existing worksheet content downward. It is not the same as selecting a row and pressing Delete, which removes cell contents but generally leaves the row itself in place. Nor is it the same as typing into an occupied row, which can replace existing data. This distinction matters when working with records: if you need to preserve every existing entry, insert a row; if you only need to empty a row, clear its contents instead.

A worksheet has a maximum of 1,048,576 rows. If you are already at the bottom of the sheet, Excel cannot add another worksheet row. In ordinary lists this limit is unlikely to be reached, but very large imports or generated datasets can approach it. Also consider whether inserting a full row is appropriate in a formatted report: it may shift notes, totals, or unrelated content elsewhere on the same sheet, not only the visible table.

Frequently Asked Questions

What is the shortcut to insert a row in Excel?

On Windows, select the row and press Ctrl+Shift++, commonly typed as Ctrl+Shift+= because plus shares the equals key. Excel inserts a blank row above the selected row.

How do I insert a row without a mouse?

Use the arrow keys to move to a cell in the target row, press Shift+Space to select the full row, then use the insert shortcut. If your keyboard layout makes the plus shortcut inconvenient, use Excel’s ribbon Key Tips or another available Insert command.

How do I insert multiple rows in Excel?

Select as many adjacent row headers as the number of rows you want to add, then use the insert shortcut once. Selecting four rows and inserting creates four blank rows above the first selected row.

Does the shortcut insert a row above or below?

It inserts above the selected row. To add a row between rows 5 and 6, select row 6 first. The old row 6 and the rows below it move downward.

Why does Excel show an Insert dialog instead of adding a row?

Excel may show the dialog when you selected a cell rather than an entire row. Choose Entire row in the dialog, or select the row number at the left of the sheet before using the shortcut.

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.