Document Editing Problems

Fix Cannot Delete Rows or Columns in a Protected Excel Worksheet

Olivia Miller Sep 27, 2026 869 views

Question details

The user is unable to delete rows or columns in a protected Excel worksheet despite having unlocked cells and explicitly enabled deletion permissions.

How to Fix Cannot Delete Rows or Columns in a Protected Excel Worksheet

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to delete rows or columns in a protected worksheet where deletion permissions are granted and inserting rows works fine.
Observed behavior: Inserting rows functions correctly, but attempting to delete rows or columns fails. The issue persists even in a newly created workbook.

Before you start

Ensure you have the password to unprotect the worksheet, as modifying structural permissions requires you to temporarily disable sheet protection.

Solution 1Recommended

Select the Entire Row or Column Before Deleting

Excel requires you to select the entire row or column header when deleting in a protected sheet, rather than just highlighting a single cell.

A common mistake when working in a protected worksheet is selecting a single cell and pressing delete. This action attempts to clear the cell's contents or shift surrounding cells, which is usually restricted by the protection settings. To delete the actual row or column, you must select it by its structural header.

Select the Header

Click directly on the row number (on the left side) or the column letter (at the top) to highlight the entire row or column.

Open Context Menu

Right-click on the highlighted row or column header.

Delete the Selection

Click 'Delete' from the context menu to remove the row or column completely.

Select the Entire Row or Column Before Deleting

Important Selection Rule: If you do not highlight the entire row or column header first, the 'Delete' option may remain grayed out or trigger an error message.

Solution 2

Verify and Reapply Worksheet Protection Settings

If selecting the whole row doesn't work, unprotect the sheet and verify that the structural elements are unlocked and deletion permissions are properly checked.

Seamless Spreadsheet Management

Manage Protected Worksheets Easily with WPS Spreadsheet

WPS Office provides a highly intuitive interface for protecting and managing your worksheets. You can easily set granular permissions for deleting rows and columns while maintaining full format compatibility with Microsoft Excel.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your .xlsx file containing the protected worksheet.
2. Unprotect the worksheet: Navigate to the 'Review' tab on the top ribbon and click 'Unprotect Sheet'. Enter the password if prompted.
3. Adjust cell locking: Highlight the rows or columns, right-click, select 'Format Cells', and uncheck the 'Locked' option under the Protection tab.
4. Re-protect with permissions: Click 'Protect Sheet' again, ensuring that 'Delete rows' and 'Delete columns' are checked in the permissions list before clicking OK.

100% compatible with Microsoft Excel (.xlsx) formats and protection settingsIntuitive worksheet protection interface for easy permission managementLightweight architecture that runs smoothly on all devicesFree to use for everyday spreadsheet and data analysis tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why can I insert rows but not delete them in a protected Excel sheet?

Inserting rows only requires the 'Insert rows' permission to be active. However, deleting rows requires both the 'Delete rows' permission to be active AND the specific cells within that row to be unlocked before the sheet is protected.

Does worksheet protection prevent deleting cell contents?

Yes, if the cells are locked. To allow users to delete cell contents without deleting the entire structural row, the specific cells must be unlocked via the 'Format Cells' menu before applying sheet protection.

What should I do if the deletion issue persists in a brand new workbook?

If newly created workbooks experience the exact same issue even with correct settings, it may be a known bug with your specific Microsoft 365 build. Check for Office updates via 'File' > 'Account' > 'Update Options', or try repairing your Office installation.

Document & File Issues