Locking cells

Resolved · Low Priority · Version 2007

Wed 29 Jun 2011, 16:47 Delegate Tim said...

Tim has attended:
Excel Intermediate course

Locking cells

How do you lock and protect cells

Thu 30 Jun 2011, 09:36 Trainer Stephen said...

RE: Locking cells

Hi Tim

Thanks for your question

To lock/unlock cells simply go to the home ribbon, and launch the font group dialogue. Go to the Protection tab and tick/un-tick the locked box

To protect cells, simply lock those cells you wish to protect and then go to Review ribbon and click Protect Sheet.

Regards

Stephen

Wed 6 Jul 2011: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010

Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature.

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

View all Excel hints and tips