Protecting single cells or a range
 

How can I protect a single cell or range so that the rest of the sheet is
able to be accessed. I can only see options to protect the whole sheet or
workbook.

Thanks in advance.

Good afternoon Ant

Protecting a worksheet only protects the cells that are locked. In a
new worksheet all cells are locked by default. Unlock the cells you
want the users to be able to edit via ctrl + 1, Protection and uncheck
the locked box. This can be done an many selected cells at once. Then
apply protection with Tools Protection Protect Sheet.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=381551

Thank you very much - well answered

"dominicb" wrote:


Good afternoon Ant

Protecting a worksheet only protects the cells that are locked. In a
new worksheet all cells are locked by default. Unlock the cells you
want the users to be able to edit via ctrl + 1, Protection and uncheck
the locked box. This can be done an many selected cells at once. Then
apply protection with Tools Protection Protect Sheet.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=381551

Hi Ant

You're welcome. And thanks for the feedback.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=381551