How do I protect part of a worksheet in an Excel workbook?

Question

Hi,

I am trying to protect a tab within an Excel worksheet.  Intent is to protect so that no one can change formatting, enter columns, delete information, etc.  However, I do want individuals to be able to enter new rows and/or edit data in cells on existing rows.  Anyone know how to do this?  I either protect all or nothing.  I looked at using ranges; however, as folks add new entries, the range will continually change.  Any thoughts? 

Help...

Answer 1

Hi @Brooks, Suzanne

I do want individuals to be able to enter new rows and/or edit data in cells on existing rows

If you use "Protect Sheet" feature in Excel to protect locked cells, you can let users insert new rows in protected area, but users can not edit data on these locked and protected cells.

'Insert Rows' is one of 'Allow all users of this worksheet to' options, but editing cells isn't a choice, which is determined by the locked or unlocked status of the cells.

For more, please refer to article 'Lock or unlock specific areas of a protected worksheet'.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---