Excel won't let me insert rows

Andrew Moore 20 Reputation points
2026-11-18T16:02:51.34+00:00

I cannot insert rows in Excel. This is happening only on one tab of one spreadsheet. It is not protected. Even if I copy and paste data into a new spreadsheet, I cannot insert a row. I do not have this issue with any other spreadsheets or tabs.

Please help!!

Thank you,

Andrew

Microsoft 365 and Office | Excel | For home | Windows
0 comments No comments

Answer accepted by question author
Ian-T 17,400 Reputation points Microsoft External Staff Moderator
2026-11-18T23:23:07.37+00:00

Hi @Andrew Moore

Since other worksheets work normally and copying the affected data into a new workbook hasn't resolved the issue, I'd like to suggest a couple of checks to help isolate the cause.

  1. Check for an Excel Table: Click inside the affected data. If the Table Design tab appears, right-click a row and try Insert > Table Rows Above.
  2. Check merged cells: Look for merged cells around the insertion point. If present, temporarily unmerge them and try again.
  3. Try Paste Special > Values: Copy only the actual data range into a completely blank workbook using Paste Special > Values, then test whether you can insert a row.

The third test is particularly useful because it avoids transferring the original formatting and worksheet objects.

Could you also confirm what exactly happens when you try inserting a row? For example, do you receive an error message, is Insert unavailable, or does Excel simply not respond?

That information would help us determine the next troubleshooting step without making unnecessary changes to your workbook.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.