Restrict spreadsheet to data entry only

[Jon Lewis]

Fairly new to Excel. Once I've set up the structure of my
spreadsheet, and entered the formulae for calculated cells etc, how
can I ensure that the spreadsheet is used just for data entry and that
the structure cannot be altered in any way?

TIA

 

[daniels012]

You can use protection.
You need to go to every cell you want for data entry and unprotect tha
cell. You can select multiple cells... right mouse click... Then hi
format cells... The last tab says protection, select it and click th
check box to unprotect these items.
Now you can then in the menu bar hit Tools... Protection... and the
Protect Sheet.
You then can enter a password or just hit enter.

Your sheet will then be protected.


Hope this helps!
Michae

 

[Jon Lewis]

Thanks Michael,

Sounds like that will work .