98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+course - Excel 2007
microsoft+excel+course - Excel 2007
Resolved · Low Priority · Version Standard
Gemma has attended:
Excel Introduction course
PowerPoint Introduction course
Excel 2007
How do you password protect a spreadsheet?
RE: Excel 2007
Hi Gemma, Thanks for the post, in answer to your question, to protect the worksheet you would choose the menu option Tools, Protection and then from the pop out choose Protect Worksheet, the application of a password is optional, you will have to enter it twice, the second time for confirmation. To protect the Workbook you would choose Menu option, File Save As and in the dialog box choose the Menu Option Tools, within the the pop out, choose General Options, insert your chosen password twice, remember if you lose the password you will not be able to gain access to the workbook. Hope that helps, best regards Pete.
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:Generate randon numbersSome types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it: |