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

excel training microsoft - protecting worksheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Protecting Worksheets

excel training microsoft - Protecting Worksheets

ResolvedVersion Standard

Moira has attended:
Excel Advanced course

Protecting Worksheets

Please can you advise how you protect a worksheet and also how to protect certain cells within a worksheet so no one else who is using the spreadsheet can change cells that contain formula?Many thanks.

RE: Protecting Worksheets

Cells are protected with a two stage process.

All cells are locked by default

By clicking on format > cells, then navigating to the PROTECTION Tab, you will see a tick box saying locked.
You would need to unlock the cells you do not want to protect.

Protection only works once you switch the functionality on.
To do this, click on TOOLS > PROTECTION > PROTECT SHEET. Same to unprotect

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

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.1 secs.