Cell Protection

Hi Ariyann, thanks for the query. To achieve this, you need to do three things.

1) Select the entire worksheet and click Format-Cells, the Protection tab and deselect the "Locked" tickbox, so all cells are unlocked.

2) Then repeat the process, but this time just select the cell you want to protect and make sure the "Locked" tickbox is selected.

3) Then Tools-Protection-Protect Sheet. Make sure that "select Locked cells" is deselected and "select unlocked cells" is selected. Hit OK and your cell will be untouchable!

You can add a password to prevent users undoing all this, and add in various other levels of security into the Protect Sheet dialog box.

Hope this helps,

Anthony