preventing formula deletion

C

chris ings

If I set up a simple spreadsheet with data entry required in, say, cell
A1 to A3 and a result calculated in A4 using a formula, how do I preven
inadvertent data entry in A4 or interference with the formula by th
operator while still allowing the calculation to take place
 
J

Jim Rech

When you want to prevent some cells from being modified you first unlock all
cells that you want to be changeable. Use Format, Cells, Protection and
uncheck Locked. Step 2 is to then protect the worksheet (Tools, Protection,
Protect Sheet). This prevents locked cells from being changed.

--
Jim
|
| If I set up a simple spreadsheet with data entry required in, say, cells
| A1 to A3 and a result calculated in A4 using a formula, how do I prevent
| inadvertent data entry in A4 or interference with the formula by the
| operator while still allowing the calculation to take place?
|
|
|
|
| --
| chris ings
 
Top