I have a table of say 100 rows. I want to prevent some specific rows from being deleted. However, I want to be able to add additional rows, delete other rows and in general operate the rest of the table without restriction. How do I do this?
I have a table of say 100 rows. I want to prevent some specific rows from being deleted. However, I want to be able to add additional rows, delete other rows and in general operate the rest of the table without restriction. How do I do this?
Hi,
You can do this by using "Protect Sheet" option under the Review Tab.
1. Please select the whole sheet -> Right Click - > Format Cells
2. Go to Protection Tab
3. Uncheck both "Locked" & "Hidden" (in case if they are ticked)
4. Press Ok
5. Select the rows you want to prevent from editing
6. Go to Format Cells, Protection Tab again
7. Select the tick mark "Locked" -> Ok
8. Go to Review Tab -> Select "Protect Sheet"
9. Provide a password -> Ok
Now you will not be able to edit the selected rows without the password.
Regards,
Chandra
Please click on ‘ * Add Reputation’ if I was helpful in resolving the issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks