Forum Discussion
Worksheet Protection question(s)
Greetings!
I have a worksheet that has a few tables on it.
Is there a way to protect the tables from accidently being changed to a range (which has happened) without protecting the cells that need to be changed?
I appreciate any assistance. Thank you in advance.
Take this to protect the worksheet with “Allow editing of objects”
• Go to Review > Protect Sheet.
• In the dialog, leave “Insert rows” / “Delete rows” / “Format cells” unchecked, but allow “Select unlocked cells”.
• Unlock the table’s data cells (via Format Cells > Protection > Unlocked) so users can still type into them.
• This way, the Convert to Range command is disabled because it counts as a structural change.
2 Replies
Take this to protect the worksheet with “Allow editing of objects”
• Go to Review > Protect Sheet.
• In the dialog, leave “Insert rows” / “Delete rows” / “Format cells” unchecked, but allow “Select unlocked cells”.
• Unlock the table’s data cells (via Format Cells > Protection > Unlocked) so users can still type into them.
• This way, the Convert to Range command is disabled because it counts as a structural change.Yes. Protect the worksheet but first, unlock the cells you need to be editable.
Right-click your data entry cells > Format Cells > Protection tab > Uncheck "Locked". Then, review your table's design to ensure the "Convert to Range" option is greyed out for other users.
