Jay has attended:
Excel Intermediate course
Excel Advanced course
Protecting Cells
If I wanted to just protect cells that have a formula in what's the best way to do this covering the whole sheet?
Also how do I protect the worksheet where a notification comes up if its trying to be edited in any part of the sheet?
RE: Protecting Cells
Hi
To protect only formulas start by unlocking all the non-formula cells.
1. Select all cells, Format Cells, Protection
uncheck the Locked cells option
2. Now select the formulas by
F5
Special
Formulas
Format Cells, Protection
Check the Locked cells option
3. Finally select Review, Protect Sheet
Enter a password if you wish
The Worksheet is now protected. If you try to edit any of the formula cells there will be a prompt.
See the Excel Intermediate reference guide for more info on protecting cells.
Cheers
Doug
Best STL
RE: Protecting Cells
Hi,
i can still type over the formulas though? i want it so just know one can type over them?
regards
Jay
RE: Protecting Cells
Hi,
i can still type over the formulas though? i want it so just know one can type over them?
regards
Jay
RE: Protecting Cells
also say i want to lock everything that is not blank and be able to write in the blanks and when i write in the blanks then they lock so you cant edit?
best way to do this regards Jay
RE: Protecting Cells
If you want to type into the blank cells then unlock them first before protecting the sheet.
Start by unlocking all cells including blank ones.
Then select the formulas and lock them with Format, Cells, Protection.
Cheers
Doug
