Deleting rows in a protected sheet in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-207371%22%20slang%3D%22en-US%22%3EDeleting%20rows%20in%20a%20protected%20sheet%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-207371%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Microsoft%20Excel%202016.%3C%2FP%3E%3CP%3EI%20created%20a%20document%2C%20entered%20data%20in%20it%20and%20protected%20it%20from%20the%20review%20tab.%3C%2FP%3E%3CP%3EThe%20options%20that%20I%20allowed%20for%20anyone%20who%20gets%20access%20to%20this%20worksheet%20(without%20unprotecting%20it)%20are%3A%3C%2FP%3E%3CP%3E1.%20Select%20Locked%20Cells%3C%2FP%3E%3CP%3E2.%20Select%20Unlocked%20Cells%3C%2FP%3E%3CP%3E3.%20Insert%20Rows%3C%2FP%3E%3CP%3E4.%20Delete%20Rows%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20that%20I%20am%20facing%20right%20now%20is%20that%20when%20I%20am%20trying%20to%20insert%20a%20row%2C%20a%20new%20row%20is%20inserted%2C%20but%20when%20I%20am%20trying%20to%20delete%20a%20row%2C%20the%20row%20is%20not%20being%20deleted.%20Instead%20a%20dialog%20box%20appears%20saying%20%22You%20are%20trying%20to%20delete%20a%20row%20that%20contains%20a%20locked%20cell.%20Locked%20cells%20cannot%20be%20deleted%20while%20the%20worksheet%20is%20protected.%20To%20delete%20a%20locked%20cell%2C%20first%20remove%20protection%20using%20the%20unprotect%20sheet%20command%20(Review%20Tab%2C%20Changes%20Group).%20You%20may%20be%20prompted%20for%20a%20password.%22%3C%2FP%3E%3CP%3EAm%20I%20wrong%20somewhere%3F%20Have%20I%20missed%20something%3F%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20a%20solution%20to%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-207371%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDelete%20Rows%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eprotection%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-207523%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20rows%20in%20a%20protected%20sheet%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-207523%22%20slang%3D%22en-US%22%3E%3CP%3EReference%20Step%202%20at%20this%20link.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F4132-excel-insert-delete-row-in-protected-sheet.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F4132-excel-insert-delete-row-in-protected-sheet.html%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20need%20to%20uncheck%20the%20Locked%20Box%20in%20the%20cell%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am using Microsoft Excel 2016.

I created a document, entered data in it and protected it from the review tab.

The options that I allowed for anyone who gets access to this worksheet (without unprotecting it) are:

1. Select Locked Cells

2. Select Unlocked Cells

3. Insert Rows

4. Delete Rows

 

The problem that I am facing right now is that when I am trying to insert a row, a new row is inserted, but when I am trying to delete a row, the row is not being deleted. Instead a dialog box appears saying "You are trying to delete a row that contains a locked cell. Locked cells cannot be deleted while the worksheet is protected. To delete a locked cell, first remove protection using the unprotect sheet command (Review Tab, Changes Group). You may be prompted for a password."

Am I wrong somewhere? Have I missed something?

Please let me know a solution to this.

1 Reply
Highlighted

Reference Step 2 at this link.

 

https://www.extendoffice.com/documents/excel/4132-excel-insert-delete-row-in-protected-sheet.html

 

You need to uncheck the Locked Box in the cell format.