Can you write-protect one cell at a time?

D

Dave Peterson

You can lock or unlock any cell (format|cells|protection tab)

And when you protect the worksheet (Tools|Protection|Protect sheet), the locked
cells won't be able to be changed by the user.

But this worksheet protection is easily broken. So it's not made to protect
intellectual property.

And there are lots of things that can't be done to a protected worksheet, you'll
want to test it to see if you're happy.
 
G

Gord Dibben

Ann

By default all cells on a sheet are locked when the sheet is protected.

CTRL + a(twice in 2003) to select all cells.

Format>Cells>Protection. Uncheck "locked" and OK

Now select the sections/rows/cells to protect and Format>Cells>Protection.
Check "locked" and OK

Tools>Protection>Protect Sheet

The section/row locking does not work if you don't protect the sheet.


Gord Dibben MS Excel MVP

Is it possible to write-protect ONE cell at a time?

Thank you
Ann
Click to expand...

Gord Dibben MS Excel MVP
 
Top