SECTION 3
Lesson 3.4: Excel Security

   

 

 

In this exercise you will practice setting up password protection on a workbook.

 

1.

Start Excel and open the workbook named Practice 12 in your Excel 2003 Practice folder.     File->Open

 

 

You will now set up a password to modify the workbook. The password you will use is Excel.

 

 

 

2.

 

Choose Tools->Options from the menu bar to display the options dialogue box, and then click the Security tab.

 

In the Password to modify: text area, type Excel, and press Enter.

 

 

You will then be asked to confirm the password.

 

 

3.

In the Confirm Password dialogue box, type Excel again and click the OK button.

 

Type Excel and click OK. To set a password to modify.

 

Next, save the workbook and close Excel.

 

 

4.

Start Excel, and choose Practice 12 from the recently used files list, or use File->Open to open the workbook.

Type Excel in the password box

And press Enter.

 

 

5.

 

 

The workbook should now open. In the previous step, you could click the Read Only button to open the workbook, but you would not be able to save any changes under the original file name.

 

Save your work and exit Excel.