Password Protecting a Workbook - Exercise

Contact Us or call 1-877-932-8228
Password Protecting a Workbook - Exercise

Password Protecting a Workbook

Duration: 5 to 10 minutes.

In this exercise, you will password protect a workbook to prevent people who do not know the password from opening it.

  1. Open Password Protect.xlsx from your Excel2013.3/Exercises folder.
  2. Save the workbook so that others cannot open it without entering the password "OpenMe!".

Solution:

  1. Click FILE > Save As:Save As Command
  2. In the Save As dialog box, click Tools > General Options:General Options
  3. Since the purpose of the password is to prevent others from opening the workbook, enter the password in the Password to open box and click OK:Enter Password
  4. In the Confirm Password dialog box, reenter the password and click OK:Confirm Password Dialog Box
  5. Back in the Save As dialog box, click Save:Save As Dialog Box
  6. In the Confirm Save As dialog box, click Yes:Confirm Save As Dialog Box
Next