Excel Won’t Insert a Row? Causes, Fixes, and Workarounds

How-to basics · Updated November 21, 2026

If Excel won’t insert a row, first select the row header where the new row should go, then choose Home > Insert > Insert Sheet Rows. If that command is unavailable or Excel shows an error, check sheet protection and whether inserting would push existing content off the bottom of the worksheet; those are two of the most common causes.

Insert a row the right way

In Excel for Microsoft 365 on Windows, a worksheet row is inserted above the row you select. Click its numbered header at the left edge of the sheet, then use Home > Insert > Insert Sheet Rows. To add several rows, select the same number of row headers first. For example, select rows 8 through 10 to insert three blank rows above row 8. Excel shifts the existing rows down; it does not overwrite the selected rows.

You can also right-click a selected row header and choose Insert. The keyboard shortcut is Ctrl+Shift+=, which may appear as Ctrl++ on some keyboards. Select a whole row first to make the intended action clear. If you select only a cell, Excel may offer to shift cells down or across rather than insert an entire worksheet row.

For a structured Excel table, add a table row rather than assuming you need a whole-sheet row. Right-click a cell in the table and, when available, choose Insert > Table Rows Above. This adds a record within the table structure, so its formulas, formatting, and filter behavior are more likely to remain consistent.

Check what the error or disabled command means

The exact symptom helps narrow down the cause. If Insert Sheet Rows is greyed out, Excel may not permit changes to the sheet, or the current selection or workbook state may limit the command. If the command is active but an error appears after you click it, the sheet may have content at its lower boundary or an incompatible layout feature. A message that Excel cannot push non-empty cells off the worksheet points specifically to the bottom-of-sheet limit.

Before changing the workbook, note the exact message and save a copy if the data matters. Then try inserting a row in a plain, empty part of the worksheet. If that works, the issue is probably tied to a particular area, such as merged cells or a table. If insertion fails everywhere, investigate protection and workbook permissions before changing cell contents.

Fix the worksheet-bottom limit

An Excel worksheet has 1,048,576 rows. Inserting a row shifts cells below the insertion point down, so Excel cannot complete the operation if doing so would push non-empty cells beyond the final row. The obstruction may be far below the visible data. A stray value, formula, or formatting applied to a distant row can make Excel treat that area as used.

On Windows, press Ctrl+End to move to the last cell Excel considers used. Compare that location with the actual end of your data. If the worksheet should end around row 500 but Ctrl+End lands near row 1,048,576, inspect the extra rows and columns before removing anything. A distant cell might contain information that is easy to overlook.

  • If the extra cells contain unwanted values or formulas, select only the confirmed unnecessary rows or cells and use Home > Clear > Clear All. Clearing removes their contents and formatting; it is different from deleting rows.
  • If whole rows below the real data are genuinely unnecessary, select those row headers, right-click, and choose Delete. Save the workbook, close it, and reopen it before checking Ctrl+End again; Excel may update the used area after reopening.
  • If only formatting is unnecessary, select the affected cells and use Home > Clear > Clear Formats. Avoid clearing an entire column or large range if it contains valid formulas, notes, or formatting you need.

Deleting cells at the bottom does not create rows beyond Excel’s limit. It removes unnecessary material that was preventing Excel from shifting cells within the existing limit. If important information really occupies the final worksheet rows, move or archive it elsewhere before inserting new rows.

Check sheet protection and permissions

A protected worksheet can prevent row insertion. Open the Review tab and look for Unprotect Sheet. If that option is available, choose it and enter the password if Excel asks for one, then try inserting again. If you do not know the password, contact the workbook owner or administrator; there is no legitimate setting that lets an ordinary user bypass a password-protected sheet.

Protection can also be configured to allow some actions but not others. A sheet owner can protect a sheet while allowing users to insert rows, but if that permission was not selected, the command may be unavailable or Excel may reject the change. Ask the owner to review the protection settings rather than removing protection from a shared or controlled workbook without approval.

In a workbook stored in OneDrive or SharePoint, confirm that you have editing permission and that the file is not open in a read-only state. A banner or title-bar indication may explain that editing is restricted. Save a copy only if your organization’s rules permit it; a copied file may not preserve the shared workbook’s intended workflow or controls.

Look at tables, merged cells, and filters

Excel tables are designed to manage records as a connected range. If you insert a worksheet row beside or through a table, Excel may adjust the table or surrounding cells depending on where the row is selected. For a new record, use the table-specific Insert option or add the row at the table boundary. This helps preserve calculated columns, banded formatting, and filter controls. A worksheet row and a table row are related, but they are not the same operation.

Merged cells can make structural edits difficult, particularly when merged areas span different numbers of rows or columns. If an error refers to merged cells, inspect the nearby range and consider using Home > Merge & Center > Unmerge Cells. Unmerging can change how text appears and may leave content only in the upper-left cell of each former merged area, so check the result before proceeding. Do not unmerge a formatted report without first preserving a copy.

Filters can make row positions confusing because some records are hidden. If you are adding a record to a filtered table, use the table’s row insertion method and confirm the new record appears as expected after clearing or adjusting the filter. A worksheet row inserted into a filtered range is not necessarily the same as adding a visible record at the bottom of the table.

Rule out other layout or workbook problems

Some workbooks use grouped worksheets. When multiple sheet tabs are selected, a change can apply to several sheets at once, and certain edits may be restricted by differences between those sheets. Check the sheet tabs: if more than one is highlighted, right-click a tab and choose Ungroup Sheets before trying again. Use care, because edits made while sheets are grouped can affect every selected sheet.

Also check whether the workbook is in a state that limits editing, such as read-only mode, a protected view, or a file opened with restricted permissions. If the ribbon is visible but edits are blocked, look for an Enable Editing button or a read-only notice and follow your organization’s security guidance. Do not enable editing for an unfamiliar file unless you trust its source.

If the failure happens only in one workbook, test a copy of the file or try the same operation in a new blank workbook. A successful insert in a new workbook suggests the problem is specific to the original sheet’s structure, protection, or contents, rather than a general Excel setting. If Excel fails across unrelated files, save your work, restart Excel, and check whether an update or an add-in is affecting the application before attempting more disruptive repairs.

Excel for Mac and Excel for the web

In Excel for Mac, the basic approach is the same: select the row header and use the Insert command on the Home tab, or use the contextual menu. Keyboard shortcuts can differ by Mac model, keyboard layout, and whether function keys require the Fn key, so use the ribbon or menu when the shortcut is unclear. The worksheet row limit and the core causes—protection, bottom-of-sheet content, and layout conflicts—are broadly the same.

In Excel for the web, select the row header and use the Home tab’s Insert controls or the row’s context menu. Some advanced workbook and protection options may be easier to inspect in the desktop app. If a command is missing in the browser, open the workbook in Excel for Microsoft 365 on Windows or Mac if you have access, while preserving the original file and checking that you have editing permission.

Prevent the problem from returning

Keep the worksheet’s used area close to its real data. Avoid applying formatting to entire columns or thousands of unused rows unless the design requires it, and remove obsolete content when a sheet is reorganized. Before inserting many rows into a critical workbook, save a copy and check formulas, references, tables, and totals afterward; Excel often adjusts references automatically, but workbook-specific formulas and layouts still deserve review.

For recurring data entry, consider storing records in an Excel table and adding new records as table rows. Tables expand with new data and make filters and structured columns easier to manage. For a report that depends on fixed row positions or merged headings, preserve a clean backup and use the worksheet’s intended layout rather than forcing inserts through complex formatting.

Frequently Asked Questions

Why is Insert Sheet Rows greyed out in Excel?
Check whether the worksheet is protected, whether you have editing permission, and whether multiple sheets are grouped. Also confirm that you selected a worksheet row header. If the sheet is protected, the owner may need to allow row insertion or unprotect it.

How do I fix Excel saying it cannot insert cells because it would push non-empty cells off the worksheet?
Use Ctrl+End on Windows to locate the last cell Excel considers used. Inspect the distant rows and columns, preserve any valid data, and clear or delete only confirmed unnecessary content. Save, close, and reopen the workbook, then try the insertion again.

Can I insert a row into an Excel table?
Yes. Right-click a table cell and choose Insert > Table Rows Above when that option is shown. This inserts a table record. If you need a worksheet row that affects cells outside the table too, select the worksheet row header and use Insert Sheet Rows instead.

Will inserting a row change my formulas?
Excel generally adjusts many cell references when rows are inserted, but the result depends on how the formulas and workbook are structured. Check totals, named ranges, charts, and formulas near the edited area, especially in complex workbooks or when the new row is outside a table.

Why can’t I insert a row when the sheet is filtered?
A filter hides records; it does not turn the visible rows into a separate worksheet. For a new record, add a row within the table using its insertion command, then review the filter. If the operation remains blocked, check protection, merged cells, and the bottom-of-sheet limit.

Related

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.