Excel Not Letting Me Insert a Row? Fixes That Work

How-to basics · Updated November 18, 2026

If Excel won’t let you insert a row, select the row number where it should go, then choose Home > Insert > Insert Sheet Rows. If that command fails or is unavailable, check whether the sheet is protected, the worksheet is full at its bottom edge, or the file is read-only; merged cells and table boundaries can also affect what Excel inserts.

Start with the row-insertion command

Excel inserts a worksheet row above the row you select. Click the number at the left edge of the sheet to select the entire row, rather than clicking a single cell, and use Home > Insert > Insert Sheet Rows. You can also right-click the selected row heading and choose Insert. Selecting several row headings first inserts the same number of rows above them.

On Windows, Ctrl+Shift++ (often entered as Ctrl+Shift+=) inserts rows when entire row headings are selected. If cells rather than full rows are selected, Excel may show an Insert dialog asking whether to shift cells down or shift them right. That is a different operation and can disrupt the layout, so choose the whole row when you intend to add a worksheet row.

If the Insert command is dimmed, or Excel displays an error, note the exact message before trying workarounds. A disabled command often points to protection or permissions; an error about pushing non-empty cells off the worksheet points to the sheet’s boundary. The message helps distinguish a genuine limitation from a selection mistake.

Check whether the worksheet is protected

Sheet protection can prevent users from inserting rows, even when they can edit some existing cells. Open the Review tab and look for Unprotect Sheet. If the command is available, select it; Excel may request the password used to protect the sheet. Once protection is removed, try inserting the row again. If you do not know the password, ask the workbook owner or administrator rather than trying to bypass protection.

A protected sheet can be configured to allow some actions and block others. For example, users might be able to enter values in unlocked cells but not insert or delete rows. The workbook’s structure protection is a separate feature: Review > Protect Workbook controls structural changes such as adding, deleting, moving, or hiding worksheets, not ordinary row insertion within a sheet. Check sheet protection first when the row command itself is unavailable.

If you own the workbook and need protection to remain in place, unprotect the sheet, make the structural change, then review the protection settings before protecting it again. In a shared or managed workbook, coordinate with the owner, since changing protection can affect other people’s workflow.

Fix the worksheet’s last-row limit

An Excel worksheet has a fixed size: 1,048,576 rows and 16,384 columns, with the last column labeled XFD. Inserting a row near the bottom would push existing content off the worksheet. Excel will refuse if it detects cells that would be displaced, and the warning may refer to non-empty cells even when the visible area looks blank. Formatting or other cell details far below the data can make the used area extend much farther than expected.

First press Ctrl+End on Windows to see where Excel considers the used area to end. If it jumps far below or to the right of your real data, inspect that region before deleting anything. Do not assume that the apparently empty rows are disposable: a distant cell may contain a formula, note, or formatting someone relies on.

If you confirm that the extra rows are not needed, select the first truly unused row through row 1,048,576 using the Name Box to the left of the formula bar. For example, entering 500:1048576 selects those entire rows; use this only if row 500 and everything beneath it are genuinely unnecessary. Choose Home > Delete > Delete Sheet Rows. If unwanted used cells extend to the last column, select the first truly unused column through XFD and choose Home > Delete > Delete Sheet Columns. Save the workbook, close it, and reopen it before checking whether insertion now works. Deleting whole rows or columns is different from pressing Delete to clear cell contents, which may leave formatting or other used-range information behind.

Understand rows inside an Excel table

A formatted Excel table is not the same thing as a worksheet range. To add a record within a table, right-click a cell in the table row where the new record belongs and choose Insert > Table Rows Above. This adds a table row and normally carries the table’s formatting and calculated-column behavior into it. You can also enter data in the row immediately below a table, which often expands the table automatically, but using the insert command is clearer when you need a row in a particular position.

If you select a worksheet row heading and insert a sheet row where a table sits, Excel may expand or adjust the table as part of the worksheet change. When you only want another table record, use the table-specific option so you can see that the new row belongs to the table. This matters for filters, table formulas, and charts or PivotTables that use the table as their source.

Also check whether the apparent table is actually an ordinary range with filter buttons. A real table has table-specific controls and a Table Design tab when selected. For a normal range, use the row-heading method unless you intend to insert cells only within part of the range.

Look for merged cells and filtered data

Merged cells can interfere with inserting or shifting cells when the proposed row crosses a merged area. If Excel reports that the action cannot be performed on merged cells, inspect the region around the insertion point. Select the affected merged cells and use Home > Merge & Center > Unmerge Cells. Review the content afterward: unmerging does not recreate a multi-cell layout, and the text is generally retained in one cell rather than copied into every cell.

A filter by itself is not usually a reason Excel cannot insert a worksheet row. However, filtering can make the sheet confusing: some records are hidden, so a newly inserted row may not appear where you expect among visible records. Clear the filter temporarily, insert the row in the intended location, and then reapply or restore the filter. In a table, use the table-row insertion command to add a record to the data rather than trying to position it among only the currently visible results.

Be cautious when selecting visible cells in a filtered list and pasting or shifting data. The selection may not represent one continuous block of rows. If the goal is simply to add a record, adding it as a table row is usually less error-prone than rearranging filtered worksheet cells.

Check file access, sharing, and editing mode

If Excel opens the workbook as read-only, in Protected View, or with viewing rather than editing access, you may be able to inspect the sheet but not change its structure. In desktop Excel, check the title bar and any Protected View banner. Only select Enable Editing if you trust the file and its source. If the workbook is stored in OneDrive or SharePoint, confirm that your account has editing permission and that Excel is not showing the file in a viewing mode.

A workbook can also be locked for editing by another process or opened in a way that restricts changes. Save a separate copy if you are allowed to do so, then test row insertion in the copy. If the copy works but the shared original does not, investigate its permissions, checkout status, or organizational controls with the file owner. Do not remove access controls or overwrite a shared workbook just to get past an error.

When the issue affects only one workbook, the cause is likely in that workbook’s protection, structure, or access settings. If row insertion fails in new blank workbooks too, check that Excel is functioning normally and that you are not working in a restricted environment or using a limited account.

Use a short diagnostic sequence

When the cause is unclear, work through these checks in order. This avoids deleting data or changing protection before you know what is blocking the command:

  1. Select the row heading and try Home > Insert > Insert Sheet Rows.
  2. Read any error message and check Review for Unprotect Sheet.
  3. Confirm that you have editing permission and are not in Protected View or viewing mode.
  4. If the warning mentions cells at the edge of the sheet, inspect the used area with Ctrl+End and remove only confirmed-unneeded rows or columns.
  5. If the target is part of a table, use Insert > Table Rows Above; if merged cells are involved, review the layout before unmerging.
  6. Save, close, and reopen the workbook, then test again. Keep a backup before deleting rows, columns, or formatting.

This sequence also helps identify the difference between “insert a table record” and “insert an entire worksheet row.” Those actions can look similar on screen, but they change different structures and can affect formulas, filters, and surrounding layout differently.

Excel for Mac and Excel for the web

The menu approach is the most consistent across Microsoft 365 versions: select a row heading and use the Insert command on the ribbon or its right-click menu. In Excel for Mac, the ribbon labels and available context-menu wording are similar, but keyboard shortcuts can differ by keyboard layout and macOS settings. Use the menu if a Windows shortcut does not work. On the web, confirm that the workbook is in editing mode, then select the row heading and use the Insert command; some actions can be restricted by browser-based permissions or workbook state.

For files shared online, changes may take a moment to sync. Wait for the save indicator to finish before closing the workbook, and check whether another user’s edit or an organization’s permissions are affecting access. If a feature or command is missing in the web version, open the workbook in the desktop app if you have permission and need the fuller set of workbook controls.

Frequently Asked Questions

Why does Excel say it can’t insert new cells because it would push non-empty cells off the end? Excel believes cells near the worksheet’s last row or column would be displaced. Inspect the area identified by Ctrl+End, confirm what is truly unused, delete only unnecessary entire rows or columns, then save and reopen the workbook.

Why is Insert Sheet Rows grayed out? The sheet may be protected, the workbook may be open without editing permission, or the file may be in a restricted viewing state. Check Review > Unprotect Sheet and confirm that you can edit the file. If it is shared, ask the owner to review your access.

Does pressing Delete make Excel forget the last used row? Not necessarily. Delete commonly clears cell contents while leaving formatting or other information in place. When confirmed-safe unused rows or columns are causing a boundary issue, deleting the whole rows or columns and then saving and reopening is more appropriate.

How do I add a row to an Excel table without breaking it? Right-click a cell in the table row above the desired position and choose Insert > Table Rows Above. This adds a record within the table, keeping it part of the table’s data and associated features.

Can I insert a row in a protected worksheet? Only if the protection settings permit that action. Otherwise, someone with the necessary password or permissions must unprotect the sheet, insert the row, and apply protection again if needed.

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.