Excel Insert Row Not Working? Fix the Common Causes

If Excel will not insert a row, select the row number where you want the new row, then choose Home > Insert > Insert Sheet Rows. If that command is unavailable or Excel displays an error, check whether the sheet is protected, the insertion would push cells past the worksheet limit, or the selection includes merged cells; the right fix depends on the message and where you are inserting.

Insert a worksheet row the right way

Excel distinguishes between inserting an entire worksheet row and inserting cells within a selected range. To insert a full row in Microsoft Excel for Microsoft 365 on Windows, click the row number at the left edge of the sheet where the new row should appear. Right-click the selected row heading and choose Insert, or use Home > Insert > Insert Sheet Rows. The new row appears above the selected row, and cells below it move down.

If you select several adjacent row headings first, Excel inserts the same number of rows above the selection. For example, selecting row headings 8 and 9 and choosing Insert creates two rows above row 8. This is useful when adding a block of records without repeating the command.

You can also select a cell and press Ctrl+Shift+plus on Windows (the plus sign may require Shift with the equals key). Excel opens the Insert dialog when it cannot infer whether you want to shift cells, insert a full row, or insert a column. Choose Entire row, then select OK. If you selected the row heading before using the shortcut, Excel can insert a whole row directly.

Check what is selected and where the row goes

A frequent cause of confusion is selecting a cell range rather than the row heading. With a cell range selected, the Insert command may shift only the selected cells and ask which direction to move existing content. That is different from inserting a worksheet row and can make surrounding data look misaligned. If you want a full row across the sheet, click its numbered row header before inserting.

Also check the active location. Inserting above row 1 is not possible because there is no row above it; choose row 1 to insert a new row at the top. If the active cell is inside a structured Excel table, the table may offer a table-row operation rather than a worksheet-row operation. Decide whether the new record belongs inside the table or elsewhere on the sheet before choosing a command.

For a quick check, click a blank cell in the target area and look at the row number beside it. The row heading should highlight when you select it. If only one cell is highlighted, right-clicking and choosing Insert may open a dialog rather than inserting a complete row.

Look for worksheet protection

A protected worksheet can prevent row insertion even when the command is visible. On Windows, open Review > Unprotect Sheet. If the sheet was protected with a password, Excel asks for it; you will need the password or help from the workbook owner. Do not assume the workbook is broken simply because the insertion command is disabled.

If you manage the workbook and know its password, you can change the permissions: choose Review > Protect Sheet, enter the password if prompted, and allow Insert rows in the protection options. Then protect the sheet again if you still need to prevent other edits. Protection options control what users may do; allowing row insertion does not give them permission to change every locked cell.

Workbook structure protection is a separate setting from worksheet protection. It can restrict actions such as adding, deleting, moving, hiding, or renaming sheets, but it is not usually the setting that blocks inserting a row within an existing worksheet. Check the sheet-level protection first.

Understand Excel tables and filters

An Excel table is a formatted, structured range with its own headers, filters, and automatic expansion behavior. To add a record within a table, click the last cell in its last data row and press Tab; Excel creates a new table row. You can also right-click a table row and choose Insert > Table Rows Above. These methods keep the new record in the table, so calculated columns and table formatting can extend appropriately.

Inserting a worksheet row above or within a table can also change the sheet layout, but it is not always the best way to add a record. If you add a row outside the table, formulas or filters that refer to the table may not include it. To confirm that a new record is part of the table, click in it and check whether the Table Design tab appears.

A filter by itself normally does not prohibit inserting worksheet rows. However, filtered or hidden records can make it seem as if Excel inserted a row in the wrong place. A worksheet row is inserted at its actual sheet position, not necessarily between the visible records in a filtered view. For a table, add the record through the table so it remains part of the filtered data; if its values do not meet the active filter, the new record may be hidden until you change or clear the filter.

Resolve merged cells and other layout conflicts

Merged cells can interfere with inserting or shifting cells, particularly when the selected area would split a merged range. Excel may show an error about merged cells or refuse the operation. Find the merge in the affected area and, if appropriate, select it and choose Home > Merge & Center > Unmerge Cells. Check the layout afterward: unmerging does not recreate the original design, and the value remains in only one of the cells.

Do not unmerge every cell in the worksheet as a first step. Identify the merge near the insertion point and consider whether the workbook relies on it for headings or print layout. If it does, a safer option may be to insert the row outside the merged range or adjust the layout deliberately before inserting.

Other sheet features, such as hidden rows or outline grouping, can obscure the result without actually blocking insertion. After adding a row, check whether rows are hidden or grouped and whether the new row is inside or outside the intended section. Use the row numbers and the Name Box to verify its sheet position rather than relying only on what is currently visible.

Fix the worksheet limit error

Excel worksheets have a maximum of 1,048,576 rows. If inserting a row would push existing content beyond the bottom of the sheet, Excel cannot complete the operation and may report that it cannot push non-empty cells off the end of the worksheet. This can happen even when the last visible data is far above the bottom: stray values, formulas, or formatting near the final rows can extend the area Excel must move.

First, inspect the bottom of the worksheet and determine whether there is real data you need to keep. If there is, move or remove it only after confirming that it is safe to do so. To clear genuinely unused rows below your data, select their row headings, then choose Home > Delete > Delete Sheet Rows. If excess formatting is the issue, select the unused area and choose Home > Clear > Clear All. Save the workbook, close it, and reopen it; Excel may then recognize a smaller used area.

Deleting rows or clearing cells is different from hiding them. Hiding unused rows does not remove their contents or make room at the bottom of the worksheet. Likewise, pressing Delete on the keyboard clears cell contents but does not delete the worksheet rows or necessarily remove formatting. Work on a copy if you are unsure whether the bottom of the sheet contains important information.

Check the workbook state and Excel version

If Insert is greyed out but the sheet is not protected, check whether the workbook is read-only, opened with view-only permissions, or stored somewhere you cannot edit. Look for a read-only notice or an editing prompt near the top of Excel. If the file is open in a shared location, ask the owner or check your access before trying to change its structure. Save an editable copy if you are permitted to do so.

Some older file formats and legacy sharing arrangements have feature restrictions. If a workbook is in Excel 97–2003 format (.xls), its worksheet limit is 65,536 rows, not the modern .xlsx limit. Saving in a newer format may help with format-related limits, but first check whether other users or systems require the older format. Use File > Save As and choose an appropriate modern Excel workbook format only when compatibility is not a concern.

In Excel for the web, you can usually insert a row by selecting a row heading, right-clicking, and choosing Insert row, or by using the available insert command on the ribbon. Labels and available options can differ from the Windows desktop app, and access permissions or a protected sheet can still prevent editing. If a particular desktop feature is unavailable in the browser, open the workbook in the desktop app if you have access.

Choose between a sheet row and shifted cells

Use Insert Sheet Rows when you need every cell below a position to move down together. This is generally the safest choice for adding a record to an ordinary worksheet table of data, because it preserves the alignment of columns across the sheet. Still, inspect nearby formulas, references, and charts afterward if the workbook contains complex calculations.

Use Insert Cells only when you intentionally want to shift a limited range and leave the rest of the sheet in place. For example, inserting cells in column B and shifting cells down can misalign those entries from related values in columns A and C. Excel’s Insert dialog helps distinguish this operation from inserting an entire row. If your data is a formal Excel table, prefer adding a table row so the record remains inside the table’s filters and structured range.

Frequently Asked Questions

Why is Insert Sheet Rows greyed out? The worksheet may be protected, the workbook may be read-only, or you may lack editing permission. Check Review > Unprotect Sheet, then check whether the file is open for editing. A workbook’s structure protection is different from protection of the individual sheet.

How do I insert multiple rows at once? Select the same number of row headings as the number of rows you want to add, then right-click and choose Insert or use Home > Insert > Insert Sheet Rows. Selecting three row headings inserts three rows above the first selected heading.

Why does Excel say it cannot push non-empty cells off the end? The insertion would move content beyond the worksheet’s last available row. Check the bottom of the sheet for data, formulas, or unnecessary formatting, and remove only what you have verified is unused.

Can I insert a row into a filtered list? Yes, but a worksheet row is inserted at its actual position and may not appear between the visible filtered records. If the list is an Excel table, add the record as a table row; the active filter may hide it if its values do not match the filter.

Why did the new row appear in the wrong place? The selection may have been a cell range rather than the intended row heading, or filters and hidden rows may be changing what you see. Check the numbered row headings and clear or adjust filters to verify the row’s actual location.

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.