In Excel for Microsoft 365 on Windows, Insert Row is usually greyed out because the worksheet is protected, the file is open in a view-only state, or Excel is still editing a cell. Check the Review tab for sheet protection, look for an Enable Editing banner, and press Esc to leave cell-edit mode; then select a row header and choose Home > Insert > Insert Sheet Rows.
First identify which Insert command is disabled
Excel has several commands that can add cells or rows, and they do not all behave the same way. Selecting a cell and choosing Insert may open a dialog asking whether to shift cells down or insert an entire row. Selecting a row number at the left edge of the sheet and using Insert Sheet Rows makes the intention unambiguous. If that specific command is unavailable, focus on worksheet or file restrictions rather than the selection method.
Try this quick check before changing workbook settings:
- Press Esc, or press Enter, to finish any cell edit or formula entry.
- Click a row number, such as 8, to select the whole row.
- Open Home > Insert and check whether Insert Sheet Rows is available.
- Right-click the selected row number and check whether Insert is available in the context menu.
If the ribbon command is grey but the context-menu command works, the issue may be where you are clicking or how the ribbon is displayed. If both are unavailable, inspect protection and access next. If Insert is available but Excel displays an error after you click it, that is a different problem: the sheet may have a layout or capacity obstacle, discussed below.
Check whether the worksheet is protected
Sheet protection is one of the most common reasons Excel disables row insertion. A protected sheet can allow people to edit selected cells while preventing structural changes such as inserting rows. The fact that you can type into some cells does not prove that the sheet is unprotected; the person who protected it may have allowed editing in particular ranges.
On Windows, open the Review tab. If you see Unprotect Sheet, the current worksheet is protected. Select it and, if prompted, enter the password set by the workbook’s owner. If the command instead says Protect Sheet, sheet protection is probably not the cause. A password cannot be recovered through the ordinary Unprotect Sheet command, so ask the file owner or administrator for the password or an editable copy rather than trying to bypass the restriction.
If you are responsible for protecting the sheet, you can control whether users are allowed to insert rows. Choose Review > Protect Sheet and, in the protection options, select Insert rows before protecting it. This permission does not remove protection; it grants that specific action while leaving other restrictions in place. To change the options on an already protected sheet, unprotect it first, adjust the settings, and protect it again.
Look for Protected View or view-only access
A workbook opened from the internet, an email attachment, or another potentially unsafe location may open in Protected View. In that mode, Excel limits editing. A yellow message bar may offer an Enable Editing button. Only select it if you trust the file and its source; Protected View is a security safeguard, not a routine formatting setting.
Access permissions can also make a workbook view-only. For example, a shared file may grant you permission to view but not edit, or an organization may open a document under a restricted policy. In Excel for the web, check whether the file is in Viewing mode and whether you have an option to switch to Editing. If you lack edit permission, ask the file owner to grant it or provide an editable copy. Making a local copy may let you change that copy, but it does not give you permission to change the original shared file.
A file marked read-only is not always the direct reason a row command is grey: Excel can sometimes let you make changes to a read-only copy while preventing you from saving over the original. The practical test is whether the command is disabled and whether Excel identifies the file as view-only, Protected View, or read-only. Do not confuse an inability to save changes with an unavailable row-insertion command.
Exit cell-edit mode and check the current selection
While you are typing directly into a cell or editing its formula in the formula bar, Excel temporarily disables commands that would change the sheet structure. The cell may show a blinking cursor, or the formula bar may be active. Press Esc to cancel the edit or Enter to commit it, then select the row header again. This is especially easy to miss when a formula is long or a cell is being edited with F2.
Selection also matters. If you select a cell range, Excel may show Insert Cells, which shifts cells rather than necessarily adding a whole worksheet row. For a complete row, click the numbered row header. To add several rows, select the same number of row headers first: selecting rows 8 through 10 and inserting adds three rows above the selection. This does not overwrite the existing rows; Excel moves them and their contents down.
Consider legacy sharing and workbook restrictions
Excel’s older Shared Workbook feature, sometimes called Shared Workbook (Legacy), has limitations on structural edits. If the workbook uses this legacy sharing mode, inserting or deleting rows may be unavailable alongside other operations. The modern coauthoring system used with many Microsoft 365 files is different: it is not accurate to assume that every shared workbook disables row insertion. Access rights, protection, and occasional collaboration conflicts still matter, but ordinary sharing alone is not a universal explanation.
Ask the workbook owner whether the file uses legacy sharing if the common checks do not explain the problem. The owner may need to review the sharing settings and decide whether to turn off the legacy feature; changing those settings can affect how other people work in the file. Save a separate copy before making major changes, particularly if the workbook is actively used by a team.
Workbook-structure protection is another setting, but it protects the workbook’s sheet structure—for example, adding, deleting, moving, hiding, or renaming worksheets. It is not the same as protecting a worksheet’s cells and is not normally the setting that controls inserting a row inside a sheet. Check the sheet-level protection first when the row command itself is disabled.
Tables, merged cells, and worksheet limits
Excel tables have their own row behavior, but being inside a table does not automatically mean rows cannot be inserted. A table is a formatted data range with features such as filter buttons and automatic expansion. To add a record, you can enter data in the row directly below the table so the table expands, or use the row-insertion command in the table area. If you need a row above a particular record, select its worksheet row header and insert a sheet row; verify that the table’s range and formulas still include the new position.
Merged cells can complicate structural edits. An insertion that would split or shift a merged range inconsistently may be rejected, or Excel may show an error rather than simply greying out the command. Review merged areas near the intended insertion point, especially when the sheet uses merged headings across several columns. If appropriate, unmerge the relevant cells, insert the row, and then recreate the layout. Avoid unmerging indiscriminately in a form or report, since that can alter its appearance and cell contents.
Excel worksheets have a fixed maximum of 1,048,576 rows. If the bottom of the sheet is occupied, Excel cannot shift cells down to make room for another row. In many cases, this produces an error after you try to insert rather than a grey command. Formatting or stray values far below the visible data can also make a sheet appear to have used more space than expected. Check the last used areas before deleting anything, because distant cells may contain important data or formulas.
Filters alone generally do not prevent inserting a worksheet row. However, inserting while a filtered list is visible can make it less obvious where the new row will appear or whether it is included in the filtered data. Clear or review the filter if the result seems unexpected; do not treat a filter icon by itself as proof that the sheet is protected.
A practical troubleshooting sequence
Work through these checks in order, stopping when the command becomes available. This avoids changing protection or sharing settings unnecessarily:
- Finish editing: press Esc or Enter, then select the row number rather than a cell.
- Check protection: on Review, look for Unprotect Sheet. If protection is intentional, request permission or a password from the owner.
- Check editing access: look for an Enable Editing banner, a Viewing label, or a notice that you lack permission to edit.
- Try the context menu: right-click the row header. If Insert works there, continue using it or inspect the ribbon display.
- Check special workbook behavior: ask whether the file uses Shared Workbook (Legacy) or has organization-level restrictions.
- If an error appears instead: inspect merged ranges and the bottom of the worksheet for content or formatting that blocks shifting cells.
When working with a shared or business-critical workbook, make a copy before testing structural changes if you are allowed to do so. Inserting a row can change references, table ranges, formulas, print layouts, and page breaks. Excel usually adjusts ordinary cell references as rows move, but custom formulas, external links, and carefully arranged reports deserve a quick review after the insertion.
Windows, Mac, and Excel for the web
The main causes are similar across Excel platforms, but the interface and access controls can differ. In Microsoft 365 for Windows, the usual worksheet-protection check is Review > Unprotect Sheet, while the row command is available from Home > Insert > Insert Sheet Rows after selecting a row header. Right-clicking the row header is a useful alternative.
In Excel for Mac, select the row header and use the Insert command from the ribbon or the row’s context menu; Review also provides sheet-protection controls, though the layout can vary by release. The Windows shortcut for selecting an entire row is Shift+Space, and the Mac equivalent is also Shift+Space in current Excel versions. Keyboard shortcuts can vary with keyboard layout and macOS settings, so the row-header menu is a reliable fallback. There is no need to use a shortcut to diagnose a protection or permission restriction.
Excel for the web may show different controls depending on whether you have editing access and on the workbook’s current state. Check that the document is in Editing mode, select the row header, and use the available Insert command or its context menu. If a feature is unavailable in the browser, opening the workbook in the desktop app may help identify the setting, but it cannot grant permissions the file owner has not given you.
Frequently Asked Questions
Why is Insert Sheet Rows greyed out but I can still edit cells?
Sheet protection can allow edits in unlocked cells while blocking row insertion. Check Review > Unprotect Sheet. The owner can allow row insertion in the Protect Sheet options if that is appropriate.
Does filtering a worksheet disable inserting rows?
A filter by itself generally does not disable row insertion. It can make the location or visibility of a new row confusing, so check the selected row and the filtered results after inserting.
Can I insert a row into a protected Excel sheet?
Only if the sheet’s protection settings permit that action. Otherwise, someone with permission must unprotect the sheet or change its protection options. If a password is requested, ask the workbook owner rather than attempting to bypass it.
Why does Excel say it cannot insert a row when Insert is available?
That is an operation error, not a disabled command. Merged cells, content near the last worksheet row, or other layout constraints can prevent Excel from shifting cells to make room. Check the affected area before removing data.
Will inserting a row in an Excel table break its formulas?
Usually, table formulas and ranges adjust as rows are added, but check calculated columns, totals, references, and filters afterward. If the workbook uses special formulas or external links, confirm that they still point to the intended data.
Does sharing a workbook always grey out Insert Row?
No. Modern coauthoring does not automatically disable row insertion. View-only permissions, sheet protection, legacy shared-workbook limitations, or a specific collaboration restriction are more useful things to investigate.
Related
- Excel Split Print Area Into Two Pages: Page Breaks
- Excel Split Contents of a Cell Into Two Cells
- Excel Split Multiline Cell Into Rows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Present PowerPoint With Notes ShowingTo present PowerPoint with notes showing only to you, add notes to your slides, connect a second display,…
- Google Sheets Freeze Bottom Row: What Works InsteadNo. Google Sheets can freeze rows at the top of a sheet, but it has no built-in command…
- Google Sheets Growth Percentage Formula: How It Works and ExamplesTo calculate growth percentage in Google Sheets, subtract the earlier value from the later value, divide by the…
- Flip the Order of Rows in Excel: Two Easy Methods That WorkTo flip rows in Excel while keeping each record together, add a helper column numbered from top to…
- How to Add Different Page Numbers in Word by SectionTo add different page numbers in Word, divide the document into sections, unlink the header or footer where…
- Save an Excel File as a Copy: Step-by-Step InstructionsTo save an Excel file as a separate copy in Microsoft 365 for Windows, open the workbook and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.