Excel Insert Row Greyed Out? Causes and How to Fix It

Errors & fixes · Updated November 19, 2026

If Excel’s Insert Row command is greyed out, the usual causes are worksheet protection, read-only access, or a selection that does not give Excel a clear row to insert. Check those in that order: confirm you can edit the workbook, unprotect the sheet or obtain permission, then select a row header and use Home > Insert > Insert Sheet Rows.

Start with the quickest checks

Before changing workbook settings, establish whether the problem affects the whole file or just one sheet. Try selecting a different worksheet and see whether its row-insertion commands are available. If they are, the issue is probably specific to the original sheet, such as protection or a table. If the command is unavailable everywhere, check whether the file is editable and whether Excel is waiting for you to finish another action.

Then select a row by clicking its number along the left edge of the worksheet. With a row selected, go to Home > Insert > Insert Sheet Rows. You can also right-click the selected row number and choose Insert. This inserts a worksheet row above the selected row. Selecting a cell instead may still allow insertion, but Excel can offer choices such as shifting cells rather than inserting a whole sheet row.

  • If you see a Protected View banner, use Enable Editing only if you trust the file and its source.
  • If the sheet is protected, ask the owner for the password or permission to unprotect it.
  • If the file is read-only, open an editable copy or request edit access.
  • If the command is active but the result is unexpected, select the row number before trying again.

What the Insert Row command does

Excel distinguishes between inserting a complete worksheet row and inserting cells within a selected area. A worksheet row spans all columns, from the leftmost to the rightmost column available in that sheet. Inserting one shifts existing rows below the insertion point downward; it does not merely add space inside a single column.

That difference matters when a worksheet contains related data in neighboring columns. If you select a few cells and choose Insert, Excel may ask whether to shift cells right or down. For a new record in a list, inserting an entire row is often the safer choice because values in the same record stay together. In a carefully designed model, however, a full-row insertion can affect formulas, formatting, charts, or references elsewhere in the workbook, so check the surrounding layout.

On Windows, with a row selected, Ctrl+Shift++ is the keyboard shortcut for inserting rows or cells, depending on the selection. On some keyboards, entering the plus sign requires the equals key as well. If the shortcut is awkward or opens a different prompt, use the ribbon or right-click menu. Excel for Mac has different keyboard behavior across keyboard layouts; selecting the row and using Home > Insert or the context menu avoids relying on a shortcut.

Check worksheet protection and permissions

Worksheet protection is one of the most common reasons row insertion is unavailable. A protected sheet can allow some actions while blocking others. For example, the person who protected it may have permitted selecting cells but not inserting rows. The fact that you can type in some cells does not prove that row insertion is allowed.

In Excel for Microsoft 365 on Windows, open the Review tab and look for Unprotect Sheet. If that command is available, select it. Excel may request a password. You need the password, or help from the workbook owner, to remove protection legitimately. After unprotecting the sheet, try inserting the row again. On Mac, the sheet-protection controls are also on the Review tab, though their placement can vary slightly by release.

If you are the person who protects the worksheet, you can change which actions are allowed. Unprotect the sheet first, then choose Review > Protect Sheet and review the permissions in the dialog. The option to insert rows is separate from the ability to select cells. Reapply protection only after choosing the permissions users need. A protected sheet is not the same as a protected workbook: workbook structure protection mainly controls actions such as adding, moving, deleting, hiding, or renaming sheets, rather than ordinary row insertion on an unprotected sheet.

Look for read-only access or Protected View

Excel cannot insert a row into a workbook that you are not allowed to edit. The file may have opened as read-only because of its file permissions, a sharing link that grants viewing rather than editing, or a setting applied by the file owner. If the title bar or a message indicates read-only access, check the sharing permissions or ask the owner for an editable copy. Saving a separate copy can let you edit your own version, but it does not change the original file or grant permission to modify the shared one.

A file downloaded from the internet or received from an untrusted location may open in Protected View. In that mode, editing is restricted. If the source is trustworthy and you are comfortable proceeding, choose Enable Editing in the warning banner. Do not enable editing just to make a button available if you do not trust the file; restricted mode is a security safeguard, not a row-insertion error.

Files stored in OneDrive or SharePoint can also be opened with view-only rather than edit access. Check the sharing details or ask the owner to change your permission. Coauthoring by itself does not normally prevent inserting rows; the important distinction is whether your account has editing rights and whether the sheet is protected.

Make sure the selection is a worksheet row

Excel changes the available commands according to what is selected. Clicking a row number selects the whole worksheet row. Clicking inside a cell selects that cell, while selecting a range or multiple separate areas can lead to different insertion options or make the intended action unclear. If Insert is greyed out, click a single row number, then check the ribbon again.

Also make sure Excel is not currently editing a cell. If the text cursor is inside the cell or the formula bar, press Enter to accept the edit or Esc to cancel it, then select the row header. A command can be unavailable while Excel is in the middle of an operation, such as editing a cell or working with certain dialog boxes. Close any open dialog that is asking for input before trying again.

Filters are not usually a reason the Insert command is disabled. However, filtered or hidden rows can make it hard to tell where a new row will appear. Selecting a visible row header gives you a clear insertion point; remember that a whole worksheet row is inserted at that position, not just a new visible record within the filtered results.

Inserting rows inside an Excel table

Excel tables have their own row-insertion behavior. A table is a structured data range with features such as header filters and automatic expansion. When the active cell is inside a table, Excel may show a table-specific option such as Insert Table Rows Above rather than the wording used for an ordinary worksheet range. That difference does not necessarily mean insertion is blocked.

To add a record, click a cell in the table row where the new record belongs, right-click, and look for the table-row insertion option. You can also enter data in the row immediately below a table; in many cases, the table expands to include it. At the last cell of the last table row, pressing Tab can create a new table row. These methods add to the table without requiring you to treat the table as an unrelated block of cells.

If table-specific insertion is unavailable, check the same basic causes: sheet protection, read-only status, and selection. A table does not override worksheet protection. When adding rows to a table, use the table command when possible so calculated columns, formatting, and structured references extend as expected. Inserting an entire worksheet row may also work, but it can affect content outside the table.

Other conditions that can look like a disabled command

Some situations change what Excel displays without being the underlying cause. For instance, grouped worksheets can make edits apply across several selected sheets. Check the sheet tabs for multiple highlighted tabs or a grouped indicator. Right-click a selected sheet tab and choose Ungroup Sheets before making a change that should affect only one sheet. Grouping is not a universal explanation for a greyed-out Insert command, but it is important to notice because a row insertion can be applied to every grouped sheet.

At the bottom of a worksheet, Excel has a fixed maximum of 1,048,576 rows. If the sheet is already at that limit, it cannot accommodate another row. In ordinary workbooks this is uncommon, but it can matter in sheets that use nearly every available row. Deleting unnecessary rows near the bottom may make space, although moving or deleting data can affect formulas and references. Make a copy before changing a large or important workbook.

Workbook structure protection is often confused with sheet protection. If Review > Protect Workbook indicates that the workbook structure is protected, that restriction normally concerns sheet-level operations, not inserting a row within an unprotected worksheet. Check the individual sheet’s protection status instead of assuming that every protection setting blocks every command.

A safe troubleshooting sequence

Use this order to identify the cause without changing more than necessary:

  1. Save the workbook, or make a copy if it contains important or shared data.
  2. Check for a Protected View banner, read-only notice, or view-only sharing permission.
  3. Click the row number where the new row should appear and try Home > Insert > Insert Sheet Rows.
  4. If the sheet is protected, check Review > Unprotect Sheet. Get the password or ask the owner if you are not authorized to remove protection.
  5. If the target is inside a table, use the table-row insertion command or add a row at the table’s end.
  6. If the issue remains, test whether insertion works on a new blank worksheet. If it does, the restriction is specific to the original sheet or workbook setup.

That last test is diagnostic, not a solution for shared work. A blank sheet may have no protection or data restrictions, so success there does not prove the original sheet is safe to modify. If you can edit the blank sheet but not the target, check the target’s protection, table context, and owner-set permissions rather than moving data into a new sheet without considering formulas and workbook design.

Frequently Asked Questions

Why is Insert Sheet Rows greyed out in Excel?

The sheet may be protected, the workbook may be read-only or open in Protected View, or Excel may not have a suitable row selected. Select the row number, check that you have edit access, and look at Review > Unprotect Sheet.

Can I insert a row in a protected Excel sheet?

Only if the sheet’s protection settings allow row insertion. If they do not, someone authorized must unprotect the sheet or change its permissions. You may be asked for the protection password; there is no legitimate setting in the ribbon that overrides a password you do not have.

Does Protect Workbook stop me from inserting rows?

Workbook structure protection generally controls operations on worksheets, such as adding, deleting, moving, or renaming sheets. Row insertion is controlled primarily by the worksheet’s protection and your ability to edit it. Check the sheet itself before changing workbook-structure settings.

Why can I add rows to a table but not the worksheet?

A table can offer its own row commands, while the worksheet command may be unavailable because of sheet protection, access rights, or selection context. Table insertion does not bypass protection; if the sheet is protected, the table’s insertion options may also be restricted.

Does filtering prevent inserting a row?

Filtering does not normally disable row insertion. It can make the insertion point less obvious because some rows are hidden from view. Select the row header where the new worksheet row should go, and remember that inserting a sheet row can affect data beyond the visible filtered records.

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.