Excel Tutorial: How To Password Protect Excel 2016


In today's digital age, protecting sensitive information is more important than ever. With the rise of cyber threats, it's crucial to take every precaution to keep your data safe. In this Excel tutorial, we will be discussing how to password protect Excel 2016, ensuring that your confidential information remains secure.

A. Importance of protecting sensitive information in Excel

Excel is a powerful tool for organizing and analyzing data, but it also has the potential to store sensitive and confidential information. Protecting this data from unauthorized access is essential for maintaining security and compliance.

B. Overview of the tutorial

In this tutorial, we will provide a step-by-step guide on how to password protect an Excel 2016 document. By the end of this tutorial, you will have the knowledge and skills to secure your spreadsheets and keep your sensitive information safe.

Key Takeaways

  • Protecting sensitive information in Excel is crucial in today's digital age
  • Following the step-by-step guide to password protect Excel 2016 ensures security and compliance
  • Password protecting Excel 2016 prevents unauthorized access and maintains confidentiality
  • Implementing password protection is a necessary precaution to keep sensitive data safe
  • By following these steps, you can confidently secure your spreadsheets and maintain privacy

Step 1: Setting up the Excel document

Before you can password protect your Excel 2016 document, you need to set up the workbook and access the file tab. Here's what you need to do:

A. Open the Excel 2016 program

Launch the Excel 2016 program on your computer by clicking on the Excel icon or searching for it in your applications folder.

B. Select the workbook you want to protect

Once Excel is open, navigate to the workbook you want to protect by selecting it from the list of recent documents or by browsing for it in your file explorer.

C. Click on the "File" tab

After opening the workbook, click on the "File" tab located in the top left corner of the Excel window. This will open a drop-down menu with various options for managing your workbook.

Step 2: Accessing the "Info" tab

Once you have your Excel 2016 document open, the next step is to access the "Info" tab, where you will find the options for protecting your workbook.

A. Click on the "Info" tab

Located at the top-left corner of your Excel window, the "Info" tab is where you can access various options for managing your document.

B. Select "Protect Workbook" from the dropdown menu

Under the "Info" tab, you will find a dropdown menu that contains several security options. Click on "Protect Workbook" to access the encryption settings.

C. Choose "Encrypt with Password"

After selecting "Protect Workbook," a new window will appear with the option to "Encrypt with Password." Click on this option to set a password for your Excel 2016 document.

Step 3: Setting the password

Once you have navigated to the "Protect Workbook" menu, you can now set your password to secure your Excel 2016 file.

A. Enter your desired password

First, enter your desired password in the provided text box. Make sure to choose a strong password that is not easily guessable to ensure the security of your Excel file.

B. Re-enter the password for confirmation

Next, re-enter the password in the confirmation text box to ensure that you have entered it correctly. This step helps to prevent any typos or errors in the password entry.

C. Click "OK" to save the changes

Once you have entered and confirmed your password, click on the "OK" button to save the changes. Your Excel 2016 file is now password protected and will require the password to be entered in order to access its contents.

Step 4: Testing the password protection

After applying the password protection to your Excel document, it's important to test if the protection is working as intended. Follow these steps to ensure the security of your workbook:

A. Close and reopen the Excel document

Once you have set the password protection, close the Excel document completely and then reopen it to start the testing process.

B. Enter the password to open the workbook

When prompted, enter the password you set for the workbook. This is a crucial step to verify that the password protection is functioning correctly.

C. Verify that the protection is working

After entering the correct password, verify that you are able to access and make changes to the workbook. If the protection is working, you should be able to view the content as usual. If you are unable to access the workbook without the correct password, the protection has been successfully applied.

Advantages of password protecting Excel 2016

Password protecting your Excel 2016 spreadsheets can provide several benefits beyond just keeping your data secure. Here are some advantages of using this feature:

  • Prevent unauthorized access to sensitive data
  • By setting a password on your Excel file, you can prevent unauthorized users from accessing sensitive data. This is especially important if you are sharing the file with others or storing it on a shared network.

  • Maintain confidentiality and privacy
  • When you password protect an Excel file, you can ensure that only those with the correct password can view its contents. This helps to maintain confidentiality and privacy, particularly for sensitive or proprietary information.

  • Comply with security policies and regulations
  • In many organizations, there are strict security policies and regulations in place to protect data. By password protecting your Excel files, you can ensure compliance with these policies and regulations, reducing the risk of data breaches and unauthorized access.


In conclusion, we have discussed the steps to password protect Excel 2016 documents. First, we went through the File menu, then selected Info, followed by the Protect Document option and finally set a password. It is important to secure sensitive information in Excel documents to prevent unauthorized access and ensure data integrity. I encourage everyone to implement password protection for their sensitive information to safeguard their data.

Excel Dashboard

ONLY $99

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles