How do we delete rows in Excel while the "sheet" remains locked?
Posted on 2014-08-01
We have designed an Excel file with locked rows.and columns for the staff to use. They need to be able to add and delete certain rows. We have found that they are able to add rows but not delete any while the sheet is locked. The users are allowed to entered data only in certain cells. There are many automatic formulas throughout the sheet. Of course, locked cells will not allow them to make any changes whereas unlocked cells will allow them to add numbers, text, etc.
We followed the instructions: In the "Change" area, we clicked "Protect Sheet". Then we checked "Insert Rows" and "Delete Rows" before we entered the password.
They are able to add rows while the sheet is locked but when they try to "delete" a row, they get the message that "You are not allowed to delete a row that contains a locked cell. Remove the protection and then delete the row." We don't want the users to know the password and make changes or delete rows.
Am I doing something wrong? The boxes are checked that would seem to allow us to add or delete rows after the sheet is locked. The add rows works but not the delete rows. Most rows contain locked and unlocked cells.
Any assistance that you can give will be appreciated. Thanks.