Locking cells

Copper Contributor
I have a sheet where I want to lock columns that auto calculate with a formula, but have the person entering the data being able to insert a row and have the formulas copy from the locked cells in the column so she never has to be given the password. Can this be done? And how?
5 Replies

@Hicksy This can be done and it is possible Go to Format Cells

 

I can provide you detailed answer but for that please provide your excel file

Can I upload it to you?
Yes you can
Please excuse my ignorance but I am very new to these forums. Could you please tell me how I can get it to you? Do you have a link I can upload to?

@Hicksy 

Replying on post select the file by browsing or just drag it here

image.png