Disallow cell entries

H

hopeace

Can I block a cell from receiving any typed in info?

And can I lock formulas from being changed?

Thanks for you help!
 
P

pinmaster

Hi

You can Protect your sheet by going to TOOLS/PROTECTION/PROTECT SHEET,
if there are cells where info will be entered then unlock those cells
only by going to FORMAT/CELLS/Protection tab and unchecking the "Lock"
option.

Hope this helps!
JG
 
H

hopeace

Thanks JG! I love this community forum!

JG: joyous giver
JG: jaunty geek (meant as compliment)
JG: jubilent graphmaker

!
 
P

pinmaster

Hi,
Yeah it sure is, I learned a ton of stuff in here. Thanks for the
feedback!

Regards
JG

JG: Jean-Guy
lol
 
Top