Protecting single cells or a range

G

Guest

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.
 
D

dominicb

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Method for protecting cells which still allows quick editing 2
protecting formulas without protecting sheet so grouping still wor 1
how do I protect a single cell 1
Protecting more than one worksheet in one workbook 1
PROTECTING CELLS 2
protecting sheets 2
Protect Only Certain Cells 2
Protecting cells 2

Top