Office Settings & Configuration

Fix Excel Cannot Insert or Delete Rows and Columns

Maira Mehtab Sep 30, 2026 869 views

Question details

The user is unable to insert or delete rows and columns in Microsoft Excel, a problem that can affect both existing spreadsheets and newly created workbooks.

How to Fix Excel Cannot Insert or Delete Rows and Columns

Product: Microsoft Excel
Device & OS: not provided
Scenario: Modifying the structure of a spreadsheet by adding or removing rows and columns to organize data.
Observed behavior: The options to insert or delete rows and columns are completely disabled or greyed out, preventing any structural changes to the document.

Before you start

Before attempting advanced troubleshooting steps like editing the Windows Registry, ensure you save a backup copy of your current workbook. It is also highly recommended to note your exact Office version for precise diagnosis.

Solution 1Recommended

Check and Disable Worksheet Protection

Excel restricts structural modifications, including inserting or deleting rows and columns, when a worksheet or workbook is protected. Unprotecting the sheet restores this functionality.

Worksheet protection is a common feature used to prevent accidental changes to a spreadsheet's layout or formulas. If a file was shared with you, the original author might have locked structural changes.

Navigate to the Review Tab

Open your Excel workbook and click on the 'Review' tab located in the top ribbon menu.

Unprotect the Sheet

Click on the 'Unprotect Sheet' or 'Unprotect Workbook' button. If the document was secured with a password, you will be prompted to enter it now.

Test Row and Column Modification

Right-click on a row or column header and verify if the 'Insert' and 'Delete' options are now active and functional.

Solution 2

Start Excel in Safe Mode to Isolate Add-ins

Third-party add-ins or COM add-ins can sometimes conflict with Excel's core features. Running Excel in Safe Mode temporarily disables them to help you identify the culprit.

Solution 3

Modify the Windows Registry (Advanced)

If software updates or system glitches have corrupted Excel's settings, resetting the application configurations through the Windows Registry can restore missing functionalities.

Free Microsoft Office alternative

Switch to WPS Office for a Bug-Free Spreadsheet Experience

If Microsoft Excel continues to restrict row and column modifications due to persistent registry errors, stubborn add-ins, or broken updates, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet editor that opens your existing Excel files seamlessly without complex troubleshooting.

1. Install WPS Office: Download and install the free WPS Office suite from the official website.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx or .xls file.
3. Manage Rows and Columns: Right-click any row or column header to easily insert or delete cells without facing Microsoft Excel's system restrictions.

Fully compatible with Microsoft Excel (.xlsx, .xls, and .csv) formats.Lightweight architecture ensures stable performance without frequent macro or add-in conflicts.Familiar user interface allows you to instantly insert, delete, and manage rows effortlessly.Completely free to download and use with comprehensive spreadsheet editing features.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the insert row option greyed out in Excel?

The 'Insert' option is usually greyed out because the worksheet or workbook is protected with a password, you have active add-ins conflicting with the software, or there is data placed at the very last row or column of the spreadsheet preventing new cells from being added.

How do I know if an add-in is preventing me from deleting columns?

You can test this by opening Excel in Safe Mode (hold the CTRL key while clicking the Excel icon). If you can delete columns without issues in Safe Mode, a third-party add-in is the root cause. You will need to disable your add-ins one by one in the settings to find the specific conflict.

Can Excel macros affect the ability to insert rows?

Yes, custom VBA macros programmed into a workbook can intentionally disable specific user interface features, including the ability to insert or delete rows, usually to protect the data structure or logic of the spreadsheet.

Why does this issue happen even when I create a new blank workbook?

If you cannot insert or delete rows in a brand-new file, the issue is not related to worksheet protection. It is most likely caused by a global Office update bug, a corrupted default Excel template file (Book.xltx), or background security software interfering with the application.

Office App Problems