If Excel is not inserting rows, first select the worksheet row header where the new row should go, then choose Home > Insert > Insert Sheet Rows. If that command is unavailable or Excel displays an error, check sheet protection, merged cells, tables or PivotTables, and whether the worksheet has reached its row limit or contains data at its bottom edge.
Start by identifying what Excel is doing
The right fix depends on whether Excel refuses the command, inserts a row in the wrong place, or appears to insert a row without changing the table you care about. Notice any error message and check whether the active cell is in an ordinary range, an Excel table, or a PivotTable. These objects have different rules for adding rows.
Also check whether you selected a whole worksheet row or only a few cells. Inserting cells can shift nearby cells in a way that looks different from adding a complete row. For a conventional row insertion, click the numbered row header at the left edge of the sheet. To add several rows, select the same number of row headers first; Excel inserts that many rows above the selection.
- Command disabled: protection or a restricted object may be involved.
- An error appears: inspect merged cells and the bottom or right edge of the worksheet.
- The new row is outside your data: insert within the table or range, not merely somewhere on the sheet.
Insert a whole worksheet row
In Excel for Microsoft 365 on Windows, click the row number where the new row belongs, right-click the row header, and choose Insert. Excel places the new row above the selected row. You can also use Home > Insert > Insert Sheet Rows. To insert three rows between rows 8 and 9, select row headers 9, 10, and 11, then use Insert; three rows are added above row 9.
The Windows keyboard shortcut is Ctrl+Shift+plus (the plus key may require Shift on your keyboard). Select the row header first so Excel inserts entire rows rather than opening the Insert dialog for individual cells. On a Mac, keyboard layouts and Excel shortcuts can differ; the Home > Insert route or the row-header context menu is a reliable alternative. Excel for the web also offers row insertion from the Home tab or the row-header context menu, though the exact menu layout can vary with the browser window.
If you select cells rather than row headers and choose Insert, Excel may ask whether to shift cells down or shift cells right. That is useful for a small block of data, but it is not the same as inserting a worksheet row. Choose Insert Sheet Rows when the entire row needs to move down together.
Check whether the sheet is protected
Worksheet protection can prevent row insertion. On Windows, open Review and look for Unprotect Sheet. If the sheet is protected, select that command; Excel may ask for a password. You need permission or the password from the workbook owner if protection was intentionally applied. Do not assume a disabled Insert command means the file is damaged.
A sheet can be protected while still allowing certain actions. When someone protects a worksheet, they can choose whether users may insert rows. If you control the workbook, review the protection settings and allow row insertion as appropriate. The exact controls appear in the Protect Sheet dialog under Review. Be aware that allowing insertion does not automatically give users permission to edit every locked cell.
Workbook structure protection is a separate setting. It restricts actions such as adding, deleting, moving, or renaming worksheets; it is not the usual cause of being unable to insert a row inside a sheet. If the problem is adding a new worksheet rather than a row, check workbook structure protection instead.
Look for the worksheet limit or occupied cells at the edge
An Excel worksheet has a maximum of 1,048,576 rows and 16,384 columns. You cannot insert a row if doing so would push existing content beyond the bottom of the grid. A frequent cause is stray content or formatting far below the visible data, sometimes in the final worksheet row. Excel may report that it cannot insert cells because doing so would push non-empty cells off the end of the worksheet.
Press Ctrl+End on Windows to move to the last cell Excel considers used. If that cell is far beyond your actual data, inspect the intervening area and the bottom of the sheet. Formatting alone can make an otherwise empty region count as used. Do not clear large areas blindly: first confirm that they contain no data, formulas, formatting, or other information you need.
To clean a genuinely unused area, select the excess rows below your real data or excess columns to its right, then choose Home > Clear > Clear All. This removes more than values, including formatting, so use it only on an area you are sure is disposable. Save the workbook, close it, and reopen it to see whether Excel has recalculated the used area. If important content is near the worksheet limit, move or remove unneeded data before inserting rows.
Understand tables and PivotTables
An Excel table expands differently from an ordinary cell range. If your data is formatted as a table, inserting a worksheet row directly above or below it may not add a record inside the table. To add a record in the table, right-click a cell in the table row where the new record should go and choose Insert > Table Rows Above. Another option is to select the last cell in the table and press Tab; Excel moves to a new row and expands the table.
This distinction matters because table features such as filters, structured references, and automatic formula fill apply to table rows. If a new worksheet row is outside the table boundary, it may not receive the table’s formatting or be included in calculations that refer to the table. Check the table outline and its header filters to confirm where the table starts and ends.
A PivotTable is different again. Excel generally does not let you insert ordinary worksheet rows inside the PivotTable layout. Add or change records in the PivotTable’s source data, then refresh the PivotTable, or insert rows outside its report area. If the report must include new source records, check that the source range or table includes them before refreshing.
Check merged cells and other layout features
Merged cells can interfere with inserting rows, particularly when merged areas differ across the region Excel must shift. A message about changing part of a merged cell is a clue. On Windows, select the affected area and use Home > Merge & Center > Unmerge Cells. Then try inserting the row again. Menu labels can differ slightly depending on the ribbon layout.
Unmerging changes the layout, so check where the text will remain and whether the sheet depends on merged headings. For a report that needs centered headings, Center Across Selection is often an alternative that does not combine cells, though changing an established layout may require care. Make a copy before changing a complex template.
Also consider whether the data is filtered or grouped. A filter hides rows that do not match its criteria; it does not remove them. Inserting a row while a filter is active can make the result seem to appear in an unexpected location or remain hidden. Clear or inspect the filter before deciding the insertion failed. Worksheet outlines can hide grouped rows as well, so expand the relevant group and check the row numbers.
Protect the workbook before troubleshooting
Before clearing cells, unmerging a formatted report, or changing a shared workbook, save a separate copy. Row insertion normally shifts cell contents and adjusts many formulas, but it can still change the layout, affect references, or disrupt a carefully arranged print area. Check formulas and key totals after the change, especially if the workbook contains charts, named ranges, or links to other sheets.
If a workbook is stored in OneDrive or SharePoint and is being edited by other people, confirm that you have edit access and that the workbook is not open in a restricted or read-only state. A permissions issue is different from a sheet-protection password. Excel for the web may present controls differently from the Windows desktop app, but the core checks remain the same: confirm edit access, inspect protection, and identify whether the target is a table or PivotTable.
Do not delete the worksheet and recreate it as a first response. That can break formulas, named ranges, charts, links, and formatting while leaving the original cause unresolved. A message or disabled command usually points to a specific constraint that can be checked first.
Frequently Asked Questions
Why is Insert Sheet Rows greyed out in Excel?
Check whether the worksheet is protected, whether you have edit permission, and whether the selected area is inside a PivotTable or another restricted layout. If you are working in a table, use its table-row insertion command instead.
Why does Excel say it cannot insert cells because it would push non-empty cells off the end?
Excel believes content or formatting near the bottom or far right of the worksheet would be pushed beyond its grid. Inspect the area beyond your real data, clear only confirmed unused cells, then save and reopen the workbook.
How do I insert multiple rows at once?
Select the same number of row headers as the rows you need, then right-click and choose Insert or use Home > Insert > Insert Sheet Rows. Excel inserts that number above the first selected row.
Can I add a row inside an Excel table?
Yes. Right-click a table row and choose Insert > Table Rows Above, or press Tab from the last cell in the table. A worksheet row inserted just outside the table may not become part of the table.
Why can’t I insert a row inside a PivotTable?
A PivotTable controls its report layout, so ordinary row insertion within that area is restricted. Change the source data or insert rows outside the PivotTable, then refresh the report if its source has changed.