Forum Discussion
Tax Guy-gmail
Jun 05, 2018Copper Contributor
prevent user from deleting cells, rows
Designed spreadsheet for another user. User enters data in all cells. Accidentally deletes cells, rows. How do I prevent user from deleting cells, rows.
10 Replies
Sort By
Hello,
format the cells that you want the user to edit and on the Protection tab of the format dialog, untick the "Locked" tick box. Next, click Review > Protect sheet. Select the options you want to allow the user to do (the default is best most of the time) and then click OK. Now only the cells that have not been "Locked" in the Format dialog can be edited.
Does that help?
cheers, teylyn
- Tax Guy-gmailCopper Contributor
I've solved the protection opportunity now. I don't know how I started this conversation and would like to start another. 2nd question -- I'm using Excel 2013 and would like to share a worksheet with a single, novice user. I haven't found a way to add a shared user who will not do any editing, only data entry. Google sheets seems much more user friendly. I'm guessing I should start with REVIEW tab.
Thank you for your help.
Hello,
to start a new question, please click the link to "General Discussion" at the top of the page and then click the button "Start a new conversation". Please do that and paste the text of your new query into the new conversation.
Tax Guy-gmail as I wrote above, the Protection tab is in the Format dialog, not in the ribbon.
- Tax Guy-gmailCopper ContributorI'm still looking for the format dialogue. Excel help wasn't any help guiding me to either format dialogue or protection tab. Could it be that I'm not displaying the correct information. How do I control the 4 rows at the top of my Excel screen?
I don't understand 'formatting the text'. I'm trying to prevent the user from deleting a cell but yet allow user to enter data in the cell.