Fix Excel When You Cannot Insert or Copy Rows and Columns
Question details
The user needs to insert and copy rows and columns in an Excel workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Editing a worksheet that requires new or copied rows and columns.
- Observed behavior
- Excel does not allow rows or columns to be inserted or copied, although the user reports no frozen panes, merged cells, borders, or colored cells.
Open the affected workbook and look for an editing warning or read-only indicator. Note any error message and whether the problem affects one worksheet or the entire workbook.
Enable Editing and Check Worksheet Protection
Use this method when the workbook was downloaded, opened read-only, or has restricted editing.
If a Protected View banner appears above the worksheet, click Enable Editing after confirming that you trust the file.
Open the Review tab and look for Unprotect Sheet. If it is available, select it and enter the password if prompted, or ask the workbook owner for permission.
If the workbook is read-only, use File > Save As to save an editable copy in a location where you have write permission.
Right-click a row number or column letter and select Insert. To test copying, select a row or column header, choose Copy, and then use the appropriate paste option at the destination.

Remove Unnecessary Cells Beyond the Used Data
Use this method if Excel reports that inserting cells would move nonempty cells off the worksheet or if formatting extends far beyond the data.
Test Rows and Columns in a New Excel Workbook
Use a new workbook to determine whether the issue is limited to the original file.
Edit Spreadsheet Rows and Columns with WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets. Its familiar interface and Microsoft Office format support make it easy to move existing files into WPS Spreadsheets, although it does not fix an underlying Excel issue.

Frequently Asked Questions
Why can't I edit a workbook I downloaded?
Excel may open downloaded files in Protected View. If you trust the source, click Enable Editing in the warning banner above the worksheet.
How do I tell if an Excel worksheet is protected?
Open the Review tab and look for Unprotect Sheet. If the sheet is protected, select that command and provide the password if requested.
Why does Excel say it cannot shift cells off the worksheet?
Content or formatting may extend to the edge of the worksheet. Inspect unused rows and columns beyond your data, delete only those you do not need, and save and reopen the workbook.
What should I do if a new workbook has the same problem?
Note the exact error message and your Excel version, then use those details to investigate an issue affecting Excel rather than just the original workbook.




