Protecting Cells

[tetschlagk]

Is there an easy way to protect cells inside a worksheet but not protect the whole worksheet in Excel2007? Looking to protect, for example, cells with formulas and not the other ones.

Thank you

 

[Excelestial]

You can select which cells you want protected by going into "FORMAT CELLS" and then the "PROTECTION" tab. First highlight those cells you want unprotected or protected...and tick the "LOCKED" option accordingly. Obviously...be sure the "LOCKED" option is not checked if you're wanting the cells unprotected.

 

[Smitty]

Welcome to the Board!

And if you have a lot of formulas you can use Goto-->Special-->Formulas to select them all at once instead of manually.

HTH,