Forum Discussion
upadhye47
Jun 25, 2018Copper Contributor
Deleting rows in a protected sheet in Excel
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 unpr...
Matt Mickle
Jun 25, 2018Bronze Contributor
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.