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

locking cells

ResolvedVersion 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.

Regards

Stephen

Wed 6 Jul 2011: Automatically marked as resolved.

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.