Emma has attended:
Excel Introduction course
Locking cells on a table
we have a spread sheet with formulas in, is there any way I can lock the cells so no body can change the formula but still add written information and the formula to still work?
thanks emma
RE: Locking cells on a table
Hi Emma
Thanks for getting in touch. You can lock down a sheet by going to the Review tab and choose Protect Sheet. You can enter a password here as well if you like.
You can also select the option Allow Users to Edit Ranges. Click New to select the cells that people can edit, and click OK. These will now be the only parts of the spreadsheet that can be edited. Your formulas will still work.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Locking cells on a table
Thank you.
Once this is done, can I copy and paste the sheet and would the locked cells stay? Or would I have to repeat it all again.
many thanks Emma
RE: Locking cells on a table
Hi Emma
Thanks for your reply. The settings you have left for what can be edited should be saved, but you will have to re-enable Sheet Protection for each sheet.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
