Locking cells on a table

Resolved · Urgent Priority · Version 2007

Sat 2 Nov 2013, 16:59 Delegate Emma said...

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

Sat 2 Nov 2013, 23:57 Trainer Gary said...

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

Mon 4 Nov 2013, 14:20 Delegate Emma said...

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

Mon 4 Nov 2013, 14:32 Trainer Gary said...

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

Mon 4 Nov 2013, 14:38 Delegate Emma said...

RE: Locking cells on a table

thank you for all your help.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips