98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Protecting Worksheets
excel training microsoft - Protecting Worksheets
Resolved · Low Priority · Version Standard
Mon 18 Jun 2007, 14:17Delegate Moira said...
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.
Mon 18 Jun 2007, 16:16Trainer Richard said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Highlighting a data rangeAttempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own! |
