How can I protect cells~?

Feb 18th, 2002, 08:46 PM

I have a spreadsheet that has cells for numbers to be inputed and cells with formulas to calculate those numbers, I'd like to protect the cells with formulas from accidently being changed, can I lock those particular cells~?
Thanks for any help~

RichardS · Feb 18th, 2002, 09:08 PM

If you select the cells you want the user to be able to change, select format, protection, and uncheck the locked box, then select tools protection to protect the sheet, this will give you the desired result.
Richard

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 08:46 PM	#1
Guest Posts: n/a	I have a spreadsheet that has cells for numbers to be inputed and cells with formulas to calculate those numbers, I'd like to protect the cells with formulas from accidently being changed, can I lock those particular cells~? Thanks for any help~

Feb 18th, 2002, 09:08 PM	#2
RichardS Board Regular Join Date: Feb 2002 Location: Victoria, Australia Posts: 761	If you select the cells you want the user to be able to change, select format, protection, and uncheck the locked box, then select tools protection to protect the sheet, this will give you the desired result. Richard