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

excel training courses - protecting cells

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Protecting Cells

excel training courses - Protecting Cells

ResolvedVersion Standard

Ian has attended:
Excel Advanced course

Protecting Cells

Please advise how it is possible to protect cells in a worksheet and not the whole worksheet

RE: Protecting Cells

Cells are protected with a two stage process.

By clicking on format > cells, then navigating to the PROTECTION Tab, you will see a tick box saying locked.

All cells are locked by default, but are only activated once you switch the functionality on.
To do this, click on TOOLS > PROTECTION > PROTECT SHEET.

All cells are locked by default, so your would need to unlock the cells you do not want to protect.

Excel tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

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