Hello,
I have a spreadsheet with data in Columns A:I
This is what I want to do:
- Prevent users from deleting entire row.
- Prevent users from deleting entire column
- Prevent users from deleting/editing all cells in column A, as well as H and I
Is this possible?
Unprotect all the cells (Select all the cells, Control+1, Protection Tab, clear Locked checkbox. Then protect only cells of column A, H & I (same steps as before, but check the box now). Then password protect entire sheet. (Reviw > Protect Sheet > OK.)
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks