locking cells

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Locking cells

Locking cells

resolvedResolved · Low Priority · Version 2007

Tim has attended:
Excel Intermediate course

Locking cells

How do you lock and protect cells

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.



Wed 6 Jul 2011: Automatically marked as resolved.


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

Server loaded in 0.07 secs.