2 Methods to Password Protect Your Excel Workbooks (Part I)

The security of Excel is rather important for individuals and companies. Here we will discuss about how to set or delete passwords for workbooks in detail.

When you are dealing with an essential Excel file, you will certainly want to protect it. There are many methods to protect your file. And Excel itself has also provided a way. You can set passwords for Excel to protect it. Here we will demonstrate how to set or delete passwords in the following passage. There are 2 ways to set passwords and 2 ways to delete it.

Set Passwords: Method 1

In this part, we will show the first method to set passwords.

  1. Click “File” in the ribbon.
  2. And then click “Save As” on the left.Save As
  3. In the “Save As” window, click the button “Tools”.General Options
  4. Next, click the option “General Options” in the menu.
  5. And then you will see this window below. Input the passwords in the text box of “Password to open”. And if you want to set password for modifying the file, you can set the passwords in the next text box.Set Passwords

Here you may also notice the option “Read-only recommended”. We will explain it later, and you may check it in this step.

  1. Then click “OK”.
  2. In the window of “Confirm Password”, input the password for open again.
  3. And then click “OK”.Confirm Password
  4. If you have set the password to modify, you will again see a window of “Confirm Password”. Here you need to input the passwords for modify.
  5. Click “OK” again.
  6. And then click the button “Save” to save the workbook.Save
  7. Now you have finished the setting, and you can open the file to test it. When you open it, you will see a password window. And you need to input the password to open it.Input Password
  8. And then click “OK”.
  9. If you have set the password for modify, you will see a password window again. And input the password for modify.Input Password for Modify
  10. And then click “OK”.

On the other hand, if you don’t need to edit the file, you can only click “Read Only” in the window.

Here you need to notice a detail. If you have checked the option “Read-only recommended” in step 5, you will see a window like the image below shows.A Window

Here Excel reminds you again. In addition, you can choose any of the option as you need.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com

Comments are closed.