training courses in excel - excel

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

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

training courses in excel - Excel

resolvedResolved · Low Priority · Version Standard

David has attended:
Excel Advanced course

Excel

How do you password protect an excel file?

RE: Excel

Hi David

Thank you for your question.

To create a password to open an Excel file:

1. Open the file you wish to create a password for.
2. Go to File - Save as.
3. In the Save As dialogue box, their is a Tools button near the top right corner - click this.
4. Select General Options.
5. Enter a password to open the file, and if you wish, a password to modify the file.
6. Reconfirm the password when prompted.
7. Click OK, then Save. If the file is an existing file, then overwrite it.

I hope this helps.
Amanda

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips


Server loaded in 0.08 secs.