

Step 2: In the Save As dialogue box, click on Tools > General Options.

Select the folder where you want you save the file, such as This PC > Downloads. Step 1: Click on the File and then click on Save As. To protect Excel 2016 via Modify Password, follow the below steps. This method is better where the owner wants to share the Excel file but does not want anyone to modify in file. With this you restrict the other person from modifying the contents of the file but he will be able to open the file in Read Only mode. If you only want to give user the privilege to see the contents, you can use this Modify Password method for Excel 2016 password. Method 2: Protect Excel 2016 via Modify Password Step 4: Now anyone who will try to open the file will first have to enter the password. Reenter the password in Confirm Password dialogue box and click OK to set the password. Now in the Left panel click on Protect Workbook and in the dropdown menu select the Encrypt with Password option. Step 1: Open the Excel file which you want to protect with password. To protect an Excel 2016 with open password, follow the steps below. With this method you will password protect Excel 2016 file and no other person will be able to open it and see the contents unless he/she knows the password.

If you do not want to share the Excel file with anyone and have personal information which you do not want other to see, then the most common method is to protect an Excel file by encrypting it with a Password. Method 1: Protect Excel 2016 with Open Password Method 5: Protect Excel 2016 through Sheet Password.Method 4: Protect Excel 2016 using Workbook Structure Password.Method 3: Protect Excel 2016 with Read Only Password.Method 2: Protect Excel 2016 via Modify Password.Method 1: Protect Excel 2016 with Open Password.So how to protect your Excel 2016 file? Some simple methods are given below and you can try any of them to protect your Microsoft Excel worksheet from spying eyes. In this article, we are going to talk about how to pasword protect Excel 2016 spreadsheet. With a password to protect your file, you do not have to worry much about someone to access your data in Excel files. If you are using Microsoft Office 2016 and have some important data to protect from alterations or prevent data from losing in Microsoft Excel 2016, password protecting your file is the best way. Excel provides you some easy security options to protect your Excel sheet if you have important data stored in your worksheet. This is because it is easy to use and many features are provided to analyze data easily and quickly. In many organizations, it is still a norm to use Microsoft Excel to analyze and store data.
