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