A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
- 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.
- Check merged cells: Look for merged cells around the insertion point. If present, temporarily unmerge them and try again.
- 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.