Forum Discussion
prevent user from deleting cells, rows
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-gmail as I wrote above, the Protection tab is in the Format dialog, not in the ribbon.
- I'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.Hello,
there are several ways to open the Format dialog.
- Right-click the cell and select "Format Cells"
- Click the icon in the lower right-hand corner of the following groups on the home ribbon: Font, Alignment, Number
- use the keyboard shortcut Ctrl-1
The format dialog looks like this with the Protection tab selected. The other tabs can be used to format other aspects of the cell.
I guess I'm not explaining myself well. Let's start over.
I want to prevent users from deleting cells, rows, columns.
None of the options do what I want unless I can't follow instructions!!
Format-protection-locked prevents user from entering data. What am I missing?
I appreciate your patience!!
