Protect your Excel files
Microsoft Excel

How to Protect Microsoft Excel With Password

Detailed guide on how to password-protect Microsoft Excel

25views

The program of choice for making spreadsheets at home, at work, or in the classroom is Microsoft Excel. Security is a vital component of working with data, and Excel takes care of that. Like Word, Access, and PowerPoint, Excel lets you password-protect your work.

The easiest approach to safeguard data whether making graphs, converting PDFs, or simply entering rows and rows of information is to learn how to password-protect Excel files, and in this guide, we will provide you with various steps to accomplish this.

1. Add a Password to an Excel Workbook

There are several options available to you when you choose Protect Workbook. Some of the options for protecting your workbooks include: Mark As Final, Encrypt with Password, Protect Current Sheet, Protect Workbook Structure, Restrict Access, and Add a Digital Signature. However, Encrypt with Password is the default because it covers everything.

  1. Open the Excel workbook, and click on File.
    Click on file
  2. Click on Protect Workbook, and choose Encrypt with Password.
    Click on protect workbook
  3. In the pop-up box, enter a strong password and click OK.
    enter a strong password
  4. Once you return to the Info window, you should see that your workbook is now protected.
    Go to the Info page

2. Add Password to an Excel Worksheet

The process to protect your worksheet is similar to a workbook. This is helpful for information that you don’t want anyone tampering with, such as reference pages, presentations, or raw data. Here is how to do it.

  1. Open your desired worksheet.
  2. Navigate to the Review tab at the top, and select Protect Sheet.
    click on the review tab
  3. Add a strong password and choose your settings.
    Pick a strong password

3. How to Remove Password in an Excel Workbook

If you no longer need to protect your workbook with a password, you can easily remove the passoword by following the instructions outlined below.

  1. Open your Excel application and click on File at the top.
    Click on file
  2. Click on Protect Workbook, then pick Encrypt with Password from the list of options.
    encrypt with password
  3. Remove the password in the pop-up box then click OK.
    remove the password
  4. Your password can also be removed from the workbook. Simply open the required workbook.
  5. Select the Review tab at the top, then click on Protect Workbook.
    choose protect workbook
  6. When the Unprotect Workbook menu appears, enter your current password then click OK.
    remove password
  7. Click on the save icon to implement the change you just made.
    click on the file option
  8. Once you do this, the workbook protection will be removed automatically.

How do you protect cells in Excel with a password?

Sometimes, you might want to protect certain cells in Microsoft Excel. To do this, follow the steps below.

  1. Begin by selecting the cells you do not want to lock.
    Pick the files you do not want to lock
  2. Right-click on the chosen cells and pick Format Cells from the list of options.
    click on the format cells option
  3. Navigate to the Protection tab.
    go to the protection tab
  4. Next, uncheck the box next to Locked.
    untick the checkbox
  5. Click OK.
  6. After doing this, take the steps outlined in the add password to an Excel worksheet section.

Adding Password to Microsoft Excel Improves Security

You can significantly improve data security by adding a password to your Excel workbook or Worksheet. By carefully following the steps outlined in this guide, you should have no trouble doing this. However, if you encounter any challenges using the steps above, let us know in the comment section below.

What Should I Do if I Forget My Excel Password?

If you forget your password, it can be quite tricky to retrieve it, and even Microsoft has said that they cannot help people who forget their workbook password. However, there is an alternative you could try. It involves using a third-party Excel unlocker tool to restore your password. There are many free ones on the internet.

How Strong Is Excel Password Protection?

Excel’s password protection adds extra security to stop unintentional or unauthorized changes to your document. However, it is essential to recognize its limitations. Excel’s password security is a good way to prevent simple illegal access. However, for very sensitive data, it is best to look into third-party encryption programs.

Can I lock cells in Excel without protecting sheet?

Yes, you can lock cells in Excel without protecting the worksheet. See the steps outlined in this guide to learn how to do this.

Leave a Response

David Ogbor
David is a tech guru with extensive knowledge in technical articles. He is passionate about writing and presents technical articles in an easy-to-understand format for easy comprehension. He aims to present easy solutions for day-to-day problems encountered while using PC. In his spare time, he likes traveling, playing sports, and singing.