If Excel’s Insert option is greyed out when you want to add a row, first press Esc, check that the sheet is not protected, and make sure you have not selected multiple worksheet tabs as a group. In Microsoft 365 for Windows, you can usually insert a row by right-clicking its row number and choosing Insert; if that command is disabled, the cause is usually a protection, selection, or file-access restriction.
What the Insert command does
Excel has several commands called Insert. To add a complete worksheet row, select the row number at the left edge of the sheet, then choose Home > Insert > Insert Sheet Rows. You can also right-click the row number and choose Insert. The new row appears above the row you selected. Selecting several row numbers first inserts the same number of rows above them.
That is different from adding a row inside an Excel table. In a table, the context menu may offer an option such as Insert > Table Rows Above, which adds a table row while keeping it within the table. Excel may also add a new table row when you type in the cell immediately below the table. These table-specific choices can be more suitable than inserting an entire worksheet row, especially when the sheet contains other data beside the table.
If the command is unavailable, look at the exact selection and the state of the workbook before changing settings. A grey command is often Excel indicating that the current sheet, selection, or access mode does not permit that action—not that the Insert feature is missing.
Check sheet protection first
A protected worksheet is one of the most common reasons row insertion is blocked. Protection can prevent changes to the sheet even when you can select cells or edit certain unlocked cells. To check, open the Review tab. If you see Unprotect Sheet, the sheet is protected. Choose it and enter the password if you know it. If the command is called Protect Sheet instead, sheet protection is not currently turned on.
Protection can be configured to allow some actions but not others. For example, a sheet may let users edit unlocked cells while preventing them from inserting rows. If you manage the workbook and want users to insert rows without removing protection, choose Review > Protect Sheet and enable the Insert rows permission in the protection options. The exact options shown depend on how the sheet is protected.
If you do not know the password, contact the workbook’s owner or administrator and ask for an unlocked copy or for row insertion to be allowed. Do not assume that copying data into a new workbook is an appropriate workaround: formulas, formatting, validation rules, links, and other workbook features may not transfer as intended. Workbook structure protection is a separate setting. It controls actions such as adding, deleting, moving, or renaming worksheets; by itself, it is not the same as protecting cells and rows on a worksheet.
Make sure worksheet tabs are not grouped
When multiple worksheet tabs are selected together, Excel groups those sheets. Edits made to one sheet can then be applied to the others, and some commands may be unavailable or behave differently. Look at the sheet tabs: grouped tabs are often highlighted together, and the workbook title may show [Group]. This can happen accidentally if you clicked one tab and then Shift-clicked another.
To end the group, right-click a selected sheet tab and choose Ungroup Sheets. You can also click a worksheet tab that is not part of the group, if one is available. Then try inserting the row again. Before making other edits, confirm that only the intended sheet is selected; otherwise, changes entered while sheets are grouped can affect several worksheets at once.
Grouping is useful when you intentionally want the same layout change on several sheets, such as adding a row in the same position on monthly worksheets. It is risky when it is accidental. If you have already made unintended changes while sheets were grouped, use Undo promptly where possible and inspect the affected sheets.
Exit cell editing and check what is selected
Excel may disable ribbon commands while you are typing into a cell or editing a formula in the formula bar. Press Esc to cancel the current edit, or press Enter to commit it, then select the row number and try again. If the cursor is still inside a cell, Excel may treat keystrokes as text rather than as worksheet commands.
Also check that you have selected a worksheet row rather than a cell inside the grid. Clicking a row number selects the whole row; clicking a cell selects only that cell. Selecting a cell does not always make the row insertion command unavailable, but selecting the row makes your intent clear and avoids choosing a different kind of insertion. If you want to insert cells rather than an entire row, select the destination cells and use Home > Insert > Insert Cells. Excel may then ask whether to shift existing cells down or to the right.
If a table is selected, check its context menu for table-row insertion choices. If cells are merged across the area where a new row would go, Excel may show an error rather than grey out Insert. That is a different problem: inspect the merged cells and consider unmerging them before inserting. Filters and frozen panes do not normally prevent inserting a worksheet row, so changing those settings is unlikely to fix a disabled command.
Check file access, Protected View, and sharing
A workbook opened in Protected View is restricted until you choose Enable Editing in the warning bar, provided you trust the file and its source. A read-only file or an account with view-only permission can also prevent changes. Check the title bar and any banner for messages such as Read-Only, Viewing, or Protected View. If you have permission to edit, switch to editing or request access from the file owner. If you do not have permission, ask the owner to grant it rather than trying to bypass the restriction.
Read-only status and a disabled Insert command are not always identical: in some cases Excel lets you make temporary changes but will not let you save them back to the original file. If you are authorized to work on a separate copy, use File > Save As and save a new workbook in an appropriate location. Saving a copy does not grant permission to change the original or resolve a password-protected sheet.
Excel’s older Shared Workbook feature, sometimes called legacy shared workbooks, has restrictions on certain structural changes, including inserting or deleting rows in some circumstances. This is not the same as modern coauthoring in Microsoft 365, where people edit a file together through OneDrive or SharePoint. If the workbook is using legacy sharing, ask its owner whether the sharing mode can be changed; do not remove sharing if other people rely on it without coordinating first.
Use the right row-insertion method
Once the sheet is editable, use a method that matches the layout you want:
- Insert one whole worksheet row: right-click the row number where the new row should appear and choose Insert. The new row is placed above it.
- Insert several whole rows: select the same number of row headers as the number of rows you need, right-click the selection, and choose Insert.
- Insert within a table: right-click a table row and use the table-row insertion option if available, or use the final row of the table to add another record.
- Insert cells without shifting an entire row: select the cells and choose Home > Insert > Insert Cells, then choose the direction for shifting existing cells.
On Windows, selecting a row and pressing Ctrl+Shift++ (plus) is another way to insert it. The ribbon and row-header context menu are easier to understand if Excel displays a prompt about shifting cells. On a Mac, use the row-header context menu or the Insert controls on the ribbon; keyboard shortcuts can differ by keyboard layout and Excel version. In Excel for the web, use the row number’s context menu to insert rows above or below. Some desktop dialog and protection options may be presented differently in the browser, but sheet permissions still apply.
A quick troubleshooting order
To find the cause without changing unrelated settings, try these checks in order:
- Press Esc or Enter to leave cell-editing mode.
- Click the row number, then check whether Insert is available from the right-click menu.
- Look for grouped worksheet tabs and choose Ungroup Sheets if the grouping was accidental.
- Open Review and check whether the sheet is protected; ask the owner for access or the correct password if needed.
- Check for a Protected View banner, read-only status, or view-only file permissions.
- If the workbook uses legacy sharing or a table, ask whether a relevant restriction or table-specific insertion method applies.
This order helps distinguish a disabled command from an insertion error. If Insert is available but Excel displays a warning after you click it, read the warning carefully: merged cells, the worksheet’s layout, or other cell constraints may be involved. If the command remains disabled after the checks, note the exact workbook status and ask its owner or your organization’s support team to review the file’s permissions and protection settings.
Frequently Asked Questions
Why is Insert Sheet Rows greyed out in Excel?
Common causes include a protected worksheet, grouped sheet tabs, an active cell edit, or restricted access to the workbook. Check those conditions first, then select the row number and try the command again.
Can I insert a row on a protected Excel sheet?
Only if the sheet’s protection settings allow row insertion. Otherwise, someone with permission must unprotect the sheet or change its protection options. If a password is required, ask the workbook owner rather than trying to bypass it.
Why can I edit cells but not insert a row?
Sheet protection can allow editing in unlocked cells while blocking structural changes such as inserting rows. Editing permission for particular cells does not necessarily include permission to change the worksheet layout.
Does filtering or freezing panes disable Insert?
Filtering and frozen panes do not normally disable worksheet row insertion. A table may provide table-specific insertion commands, but a filter alone is not usually the reason the Insert option is greyed out.
How do I add a row to an Excel table?
Use the table’s Insert > Table Rows Above option from the context menu when it is available, or add data in the row immediately below the table. This adds a table record without treating the action as an unrelated insertion elsewhere on the worksheet.
Why can I insert rows in one sheet but not another?
Each worksheet can have its own protection settings and selection state. The second sheet may be protected, grouped with other tabs, or subject to different access permissions. Check that sheet directly rather than assuming the workbook has one setting for every tab.
Related
- How to Activate Flash Fill in Excel: Shortcuts and Fixes
- How to Insert a Row in an Excel Spreadsheet: Quick Steps
- How to Make a Heat Map in Excel Using Color Scales
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- COUNTIFS Formula Not Working? Diagnose and Fix the ErrorsIf COUNTIFS is returning 0, an unexpected count, or an error, check that every criteria range is the…
- Excel Not Pasting Data Correctly? Fix Common CausesIf Excel is not pasting data correctly, press Esc to leave cell-edit mode, select the intended top-left destination…
- Excel Conditional Formatting Duplicate Rules: How to FixTo fix duplicate conditional formatting rules in Excel, select the range, go to Home > Conditional Formatting >…
- Hanging Indent in Word: Set It Up and Fix Common IssuesTo give text a hanging indent in Microsoft Word, select the paragraph or paragraphs, open the Paragraph settings…
- Excel Flash Fill Not Working? Common Causes and FixesIf Flash Fill is not working in Excel, enter one or two examples beside your source data, select…
- Excel Cell Showing 0 Instead of Result? Fix ItIf an Excel cell shows 0 instead of the result you expect, first select it and check the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.