How to protect one cell in various places in the spread sheet

Posted by Carolyn R Gallegos on September 15, 2001 6:38 PM

You gave me a way to protect a complete colume,which is
good but I can't seem tp just do one cell here and then one cell someplace else in the spread sheet. Pease explain how to do this thank you

Posted by Tom Urtis on September 15, 2001 6:49 PM

Select the individual cell(s), then click Format > Cells > Protection, select the "Locked" box, click OK, then go to Tools > Protection > Protect sheet, accept the defaults, enter an optional password, re-enter it as prompted, and click OK. Don't forget your password or you won't be able to unprotect it later.

HTH

Tom U

Posted by Robb on September 15, 2001 9:25 PM

Carolyn

If you scroll down to your previous post, I previously posted a follow up to explain how to
multi select the cells so the protect worksheet will
work for you.

Regards