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

excel

ResolvedVersion 2007

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?

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

RE: Excel 2007

Hi David

In Excel 2007 you do the following to Password Protect a Workbook:

1. Click the Office Button

2. Select Save As and click Other Formats

3. In the Save As dialog box click Tools in the bottom left corner and select General Options

4. Enter a password to open ans a password to Modify the workbook. Click OK

5. Click Save

The workbook will be password protected

Hope this helps

Carlos

Thu 12 Mar 2009: Automatically marked as resolved.

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

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.09 secs.