Excel Not Allowing Insert Row? How to Fix It

Errors & fixes · Updated November 18, 2026

If Excel won’t let you insert a row, first check whether the sheet is protected, then check whether Excel thinks the worksheet’s used area reaches its bottom or right edge. To try a normal insertion, select a row heading and choose Home > Cells > Insert > Insert Sheet Rows; the sections below explain what to check if that command is unavailable or produces an error.

Start with the insertion method

Excel can insert a row above the row you select. Click the numbered row heading at the left of the worksheet, then use Home > Cells > Insert > Insert Sheet Rows. You can also right-click the row heading and choose Insert. Selecting the row heading matters: if you select only a few cells, Excel may offer to shift those cells rather than insert a complete worksheet row, which can create a different layout.

On Windows, a keyboard method is to select a row with Shift+Space, then press Ctrl+Shift++ (the plus sign; on many keyboards this is Ctrl+Shift+=). If your keyboard makes that shortcut awkward, use the ribbon or context menu instead. Excel for Mac has similar insertion commands, but keyboard shortcuts can differ by keyboard and system settings; the row-heading context menu or the Home tab is the dependable alternative. Excel for the web also supports inserting from a row heading’s context menu.

If the command is dimmed, or Excel displays a warning, note the exact message before changing anything. A disabled command often points to protection or an editing state. An error about nonempty cells at the end of the worksheet points to a different issue: Excel believes inserting would push existing content beyond its grid.

Check sheet protection and editing state

A protected worksheet can prevent row insertion. Open the Review tab and look for Unprotect Sheet. If that command is available, select it; Excel may ask for the password used to protect the sheet. Without the password or permission from the workbook owner, you cannot legitimately remove the restriction yourself. Ask the owner to unprotect the sheet or adjust the protection settings.

When setting protection, the sheet owner can allow users to insert rows. The relevant option is typically labeled Insert rows in the Protect Sheet permissions. The owner can review the options through Review > Protect Sheet. Changing protection is not the same as changing workbook structure: Protect Workbook with the Structure option restricts actions such as adding, deleting, moving, or renaming worksheets. It normally does not, by itself, prohibit inserting rows inside a worksheet.

Also check whether Excel is still editing a cell. If the cursor is inside the formula bar or a cell, press Enter to finish the edit or Esc to cancel it, then try again. A workbook opened read-only or in Protected View may also restrict changes. If you see an Enable Editing button or a read-only notice, confirm that the file is trusted and that you have permission before enabling editing or saving a separate editable copy.

Fix the worksheet-edge error

Excel worksheets have a fixed grid: 1,048,576 rows and 16,384 columns. If Excel finds content or formatting at the very bottom or far right, it may refuse an insertion because shifting cells would move something beyond that limit. The warning often says Excel cannot insert new cells because it would push non-empty cells off the end of the worksheet. Cells that look blank can still count if they contain a formula, a space, or formatting.

To investigate, press Ctrl+End on Windows. Excel moves to what it considers the last used cell, which may be far beyond your visible data. For example, a report that ends at row 400 but jumps to a cell near row 1,048,576 may have stray content or formatting below the report. Ctrl+End is a clue, not proof of the cause: hidden data, formulas returning an empty string, and formatting can all make an area appear blank.

Before removing anything, save a copy of the workbook. Then inspect the rows below the real dataset and the columns to its right. If you confirm that entire rows below the data are unnecessary, select their row headings and use Home > Cells > Delete > Delete Sheet Rows. For unused columns, select the column headings and choose Delete Sheet Columns. Deleting entire rows or columns is more likely to reset the used area than pressing Delete to clear cell contents, because clearing contents leaves formatting behind.

Do not delete rows merely because they look empty. Check for formulas, notes, hidden information, or data used by another part of the workbook first. After deleting verified-unused rows or columns, save, close, and reopen the workbook, then try the insertion again. If the used area still appears inflated, repeat the inspection carefully or ask the workbook’s owner to review it.

Look for merged cells and grouped worksheets

Merged cells can complicate insertions, especially when the selected area crosses merged ranges of different sizes. Excel may display a message that the operation requires merged cells to be the same size, or it may refuse a shift operation. Inspect the rows around the insertion point for merged headings or labels. If a merge is the obstacle, unmerge only the affected cells after considering how the layout should look; unmerging can change alignment and leave the value in just one cell.

Check whether multiple worksheet tabs are selected. When sheets are grouped, Excel applies some edits to all selected sheets, and a difference between their layouts can make an operation fail or produce an unexpected result. Grouped tabs often appear highlighted, and the workbook title may include the word [Group]. Click a single worksheet tab to ungroup the sheets, then insert the row on the intended sheet. If you do want the same row inserted across several sheets, confirm that the sheets have compatible layouts first.

Consider tables, filters, and objects

An Excel table is not the same thing as an ordinary range. If you want a new record within a table, right-click a cell in the table and choose Insert, then choose a table-row option if it appears. Another useful method is to select the last cell in the table’s last row and press Tab; Excel adds a table row. To place a worksheet row above the table, select the worksheet row heading above the table and use Insert Sheet Rows. These methods have different effects: adding a table row expands the table, while inserting a sheet row shifts worksheet cells.

Filters can make a new row seem to disappear because filtered-out records are hidden. A row inserted into the worksheet may also sit outside the table or filtered range, so it may not inherit the table’s formatting or filter behavior. Clear or review the filter, then check the table boundaries and confirm that the new record is part of the table. If the table should include it, use a table-row insertion method rather than typing in an unrelated cell below the table.

Some errors mention objects being pushed off the worksheet. Objects include shapes, pictures, and certain controls; they may be placed far outside the visible data area. Do not delete every object as a first step, since a shape may be an important button or note. Review the objects and their positions, move or remove only those that are genuinely unnecessary, and try the insertion again.

Check workbook conditions before changing data

Several less obvious conditions can make an insertion fail or behave differently from what you expect. A file may be read-only because another process or a permission setting prevents editing. A workbook may have unusual formatting, formulas, or hidden rows near the insertion point. If the file is stored online and coauthored, check that you are editing the correct copy and that your changes can be saved. Close and reopen the workbook only after saving any work you need to keep.

If the insert command is available but the result is not where you expect, inspect hidden rows, filters, and frozen panes. Frozen panes affect what stays visible while scrolling, not whether a row exists. Similarly, hiding a row does not remove it; inserted rows can be difficult to notice when neighboring rows are hidden or a filter is active. Clear filters temporarily and use the row headings to verify the row numbers around the insertion point.

A useful diagnostic sequence is to save a copy, select a single row heading, try Insert Sheet Rows, and read any warning. If protection is indicated, resolve permissions. If Excel mentions the worksheet edge, inspect and remove only verified-unused content at the bottom or right. If the message refers to merged cells or objects, investigate those specific features instead of deleting unrelated data.

Frequently Asked Questions

Why is Insert grayed out in Excel?
Common reasons include a protected sheet, an active cell edit, or a workbook opened in a restricted or read-only state. Finish or cancel the cell edit, check Review > Unprotect Sheet, and confirm that you can edit the file. If the sheet belongs to someone else, ask its owner to grant the required permission.

Why does Excel say it cannot insert new cells because of non-empty cells at the end?
Excel thinks content or formatting near the worksheet’s final row or column would be pushed outside the grid. Use Ctrl+End on Windows to find the last cell Excel recognizes, inspect the area beyond your actual data, and delete only unused full rows or columns. Save and reopen the workbook after cleanup.

Will clearing cells fix the worksheet-edge problem?
Not always. The Delete key or Home > Editing > Clear > Clear Contents removes values but can leave formatting that still extends the used area. If the affected rows or columns are genuinely unused, deleting the entire rows or columns is more effective, but inspect them first so you do not remove needed material.

How do I add a row to an Excel table?
Right-click a table cell and choose the table-row insertion command when available, or go to the last cell in the table’s last row and press Tab. If you need a worksheet row above the table rather than a new table record, select the row heading and choose Insert Sheet Rows.

Can I insert a row on a protected worksheet?
Only if the sheet’s protection settings allow row insertion, or if protection is removed by someone authorized to do so. The owner can review the Insert rows permission under Review > Protect Sheet. A password-protected sheet cannot be unlocked through the normal interface without the password.

Does hiding a row stop Excel from inserting rows?
Hiding a row does not normally prevent insertion, but it can make the result hard to see. Filters can also hide records or keep a newly inserted worksheet row outside a table’s range. Clear or review filters and inspect the row headings to confirm where the row was added.

Related

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.