Excel Insert Row Shortcut Not Working? Fix It

If Excel’s insert-row shortcut is not working, first exit cell-editing mode, select the row or cell where the new row should go, and press Ctrl+Shift+Plus on Windows. On many keyboards, the plus sign means pressing Ctrl+Shift+=; if the shortcut still fails, use Home > Insert > Insert Sheet Rows and check whether the worksheet is protected.

The shortcut can seem unreliable because the result depends on what is selected, which keyboard layout you have, and whether Excel is currently able to change the sheet. The checks below help distinguish a key-combination problem from a selection, protection, or workbook issue.

How the insert-row shortcut works

Excel uses Ctrl+Shift+Plus to insert cells, rows, or columns, depending on the current selection. If you select a complete worksheet row first, Excel knows to insert a complete row above it. If you select only a cell, Excel may instead open an Insert dialog asking whether to shift cells down or shift cells right. That dialog is not a failure: it is Excel asking which kind of insertion you intend.

To insert one row above a particular row, click a cell in that row and press Shift+Space to select the entire worksheet row. Then press Ctrl+Shift+Plus. You can also click the row number at the left edge of the grid and use the shortcut. In either case, Excel inserts above the selected row, not below it.

On a standard Windows keyboard, the plus sign is usually typed with Shift and the equals key, so the combination is Ctrl+Shift+=. On some keyboards, a dedicated numeric-keypad plus key can be used with Ctrl. Keyboard layouts differ, so the important point is to send Excel the plus sign—not to press Ctrl and the unshifted equals key.

Try these checks first

Confirm the active window. Click inside the worksheet grid. A selected cell should have a visible outline, and Excel should be the active app.
Exit cell-editing mode. If the cursor is inside the cell text or the formula bar, press Esc to cancel the edit or Enter to commit it. Then select the row and try again.
Select the row deliberately. Click its row number, or select a cell in it and press Shift+Space. A complete row selection removes ambiguity about whether you want to insert cells or a sheet row.
Use the correct plus key. Try Ctrl+Shift+= on a typical Windows keyboard. If available, try the numeric keypad’s plus key as well.
Test the ribbon command. Choose Home > Insert > Insert Sheet Rows. If this works, the sheet can accept a row and the issue is more likely the shortcut, keyboard, or current selection.

These steps are useful because they separate common problems instead of changing several settings at once. For example, if the ribbon command is available but the key combination does nothing, focus on the keyboard layout or shortcut interception. If both methods are unavailable, investigate protection or workbook constraints.

Check for cell-editing mode and selection problems

Excel responds differently when you are editing the contents of a cell. This can happen after double-clicking a cell, pressing F2, or clicking in the formula bar. In that state, keyboard combinations may edit text or be ignored rather than act on the worksheet. Press Esc if you do not want to keep the edit, or Enter if you do, and then select the row again.

A single selected cell is also different from a selected row. With a cell selected, the shortcut may open the Insert dialog. Choose Entire row there to add a complete worksheet row above the cell’s row. If the dialog offers options to shift cells, that is expected for a cell-only selection. To avoid the extra choice, select the row number first.

Selection can be less obvious when the sheet is filtered or contains a table. A filter hides some records, but inserting a worksheet row is not the same as adding a record to the filtered results. In an Excel table, placing the cursor in the last cell of the last table row and pressing Tab can create a new table row. If the goal is to add a record within a table, use a table row rather than assuming a whole-sheet insertion is the best operation.

Check sheet protection and workbook restrictions

A protected worksheet may prevent row insertion. Open the Review tab and look for Unprotect Sheet. If the sheet is protected, select that command and provide the password if Excel requests one. If you do not know the password, contact the workbook’s owner or administrator; the shortcut cannot bypass protection.

When protecting a sheet, the author can allow certain actions, including inserting rows. If you manage the workbook, review the protection settings and permit row insertion where appropriate, or unprotect the sheet before making the change. The exact available actions depend on how the sheet was protected. Do not remove protection from a shared business workbook without checking with its owner, since protection may help preserve formulas or a carefully designed layout.

Also check whether the workbook is read-only or opened with restricted editing. A read-only state can prevent changes even though the shortcut is recognized. If Excel displays a banner or a message that editing is disabled, use the permitted editing option or ask for an editable copy. A shortcut cannot make an otherwise non-editable workbook writable.

Keyboard layout, laptop keys, and shortcut conflicts

The plus sign is the main source of confusion on compact keyboards. On many Windows laptops, there is no separate plus key in the main typing area; plus is produced by holding Shift while pressing the equals key. Therefore, the usual key sequence is Ctrl, Shift, and = together. Pressing Ctrl+= without Shift may not invoke the insert command.

On a keyboard with a numeric keypad, test its plus key if the main-key combination is awkward. Num Lock is generally relevant to numeric-keypad number entry rather than the dedicated plus key, but laptop function layers and manufacturer keyboard software can make keypad behavior vary. If other applications or keyboard utilities use the same combination, close or adjust the conflicting utility and try again in Excel.

On Mac, use the Control key rather than assuming the Windows shortcut’s Ctrl should become Command. The insert combination is generally Control+Shift+Plus, often entered as Control+Shift+= depending on the keyboard. The precise key varies with the keyboard layout and Excel version. If that is inconvenient, select the row and use Home > Insert > Insert Sheet Rows; the ribbon command avoids uncertainty about the physical plus key.

In Excel for the web, the browser can sometimes reserve keyboard combinations, and keyboard behavior can depend on the browser and operating system. Use the ribbon’s insert command if the shortcut is intercepted. The web version’s available commands and interface can change, so rely on the visible Insert options rather than assuming every desktop shortcut behaves identically.

Understand tables, merged cells, and row limits

Excel has a worksheet limit of 1,048,576 rows. If the selected row is already at the bottom of the sheet, Excel cannot insert another row beyond that limit. In normal data-entry situations, this is unusual, but it can occur in a sheet that has been filled or formatted all the way down. Consider whether excess rows or formatting can be removed, or whether the data belongs on another worksheet.

Merged cells can complicate insertions when a merged range does not match the shape of the rows being inserted. Excel may display an error or refuse the operation to avoid disrupting the layout. If that happens, inspect merged ranges near the target row and consider unmerging them before inserting, then restore the layout if needed. Merging cells across a data table is often inconvenient because it can interfere with sorting, filtering, and inserting.

Tables also have their own structure. Inserting an entire worksheet row above a table row shifts the worksheet contents and may expand or affect the table, depending on where the row is added. To add a record, click in the table and use its available row-insertion options, or press Tab from the last cell of the last table row to create a new table row. This keeps the new record within the table’s structured range, so table formatting and calculated columns can continue to apply.

Use a menu command when the shortcut keeps failing

The ribbon is a reliable alternative because it does not depend on the plus key. Select the row where the new row should appear, then choose Home > Insert > Insert Sheet Rows. If you selected only a cell, use Home > Insert > Insert Cells and choose the option to insert an entire row when prompted. Menu wording or layout may vary slightly between desktop and web versions, but the Home tab’s Insert menu is the relevant place to look.

You can also right-click a row number and choose Insert. If you right-click a cell instead, the menu may offer an Insert command that opens a dialog for choosing how cells should move. Make sure you choose the whole-row option when the goal is a sheet row. These methods are especially useful when working with a nonstandard keyboard or remote desktop where key combinations are passed through differently.

After insertion, check nearby formulas, references, formatting, and print layout. Excel usually adjusts many cell references when a row is inserted, but a workbook may also contain formulas, charts, named ranges, or external links that deserve review. Inserting a row is generally reversible with Ctrl+Z, provided you have not performed another action that changes the undo history.

When to troubleshoot Excel itself

If the shortcut fails in several workbooks, while the ribbon command works, the cause is likely outside the worksheet: a keyboard layout, a utility intercepting the keys, or an application-specific shortcut setting. Try the sequence in a new blank workbook and compare it with another keyboard if one is available. If the ribbon command also fails in a blank workbook, confirm that Excel is not in a restricted or unusual state and check whether an update or repair is appropriate through your organization’s normal support process.

If it fails in just one workbook, look first at protection, merged cells, the selected area, and whether the workbook is read-only. Test on a copy if the file is important. Avoid running random macros or changing security settings just to insert a row: the built-in ribbon command is sufficient for ordinary row insertion, and a macro is unnecessary for this task.

Frequently Asked Questions

What is the Excel shortcut to insert a row?
Select the row above which you want a new row, then press Ctrl+Shift+Plus on Windows. On many keyboards this is Ctrl+Shift+=. On Mac, the equivalent is generally Control+Shift+Plus; use the ribbon if your keyboard layout makes the plus key difficult.

Why does Ctrl+Shift+= open an Insert dialog?
You probably selected a cell rather than the whole row. Excel asks whether to shift cells or insert an entire row. Choose the entire-row option, or select the row number first and repeat the shortcut.

How do I insert a row without a keyboard shortcut?
Select the row number, then choose Home > Insert > Insert Sheet Rows. You can also right-click the row number and choose Insert.

Can I insert a row in a protected Excel sheet?
Only if the sheet’s protection settings permit row insertion. Check Review for Unprotect Sheet, and ask the workbook owner for the password or an editable version if you are not authorized to change the protection.

Does the shortcut add a row inside an Excel table?
It can affect worksheet rows around a table, but adding a table record is a distinct task. To extend a table, use its row-insertion options or press Tab in the last cell of its final row.

Does the shortcut work in Excel for the web?
It may, depending on the browser and keyboard, but a browser can intercept combinations. Select the target row and use the Insert command on the Home tab if the shortcut does not work.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.