Document Editing Problems

Fix Excel When You Cannot Insert or Copy Rows and Columns

Huda QurayshiHuda Qurayshi Nov 18, 2026 868 views

Question details

The user needs to insert and copy rows and columns in an Excel workbook.

Fix Excel When You Cannot Insert or Copy Rows and Columns
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.
Before you start

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.

Solution 1Recommended

Enable Editing and Check Worksheet Protection

Use this method when the workbook was downloaded, opened read-only, or has restricted editing.

1
Enable editing

If a Protected View banner appears above the worksheet, click Enable Editing after confirming that you trust the file.

2
Check sheet protection

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.

3
Check read-only status

If the workbook is read-only, use File > Save As to save an editable copy in a location where you have write permission.

4
Test the operation

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.

Enable Editing and Check Worksheet Protection
Free Microsoft Office alternative

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.

Insert and copy spreadsheet rows and columns using familiar controls.Open and edit Microsoft Excel XLSX and XLS files.Use a familiar interface that makes migration easier.Work with a free, lightweight Office alternative.
microsoft office alternative - wps office

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.