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

training courses in excel - excel

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

training courses in excel - Excel

ResolvedVersion 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

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.