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?

You can use this link to learn about locking certain cells in a
worksheet.

http://office.microsoft.com/en-us/as...548251033.aspx




chris ings wrote:
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

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
"chris ings" wrote in message
...
|
| 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