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 2007
Excel 2007
Resolved · Low Priority · Version 2007
Thu 5 Mar 2009, 15:19Delegate David said...
David has attended:
Excel Intermediate course
Excel Advanced course
PowerPoint Intermediate Advanced course
Excel 2007
How do I lock my excel spreadsheet so that it cannot be opened at all without a password?
Thu 5 Mar 2009, 15:46Trainer Cress said...
RE: Excel 2007
Hello David
Thank you for your question
Open the excel spreadsheet and go to File, Save As. At the top right select Tools, Options and a box should appear to let you enter a password to open and a password to modify. Enter and save.
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
Thu 12 Mar 2009: Automatically marked as resolved.
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:Make a quick copy of a worksheetHold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too. |
