How to Protecting spreadsheet with password?

 Password protection allows we to protect our data set by assigning it a password. Another user cannot read, change, or delete our data set without knowing the password.

The steps to protect a spreadsheet are as follows.

1. Click on Tools menu and select Protect Spreadsheet.

2. A Protect Document dialog box appears.

3. Type in a password.

4. Type the same password in the Confirm textbox.

5. Click on OK button.

Now, when we close the file and open it again, it will ask for the password. Remember this password so that we can open the file.

Another way of protecting a spreadsheet is as follows.

1. Select File and select the option Info.

2. Select the Protect Workbook box and choose Encrypt with Password.

3. Enter a password in the Password box, and then select OK.

4. Confirm the password in the Reenter Password box, and then select OK.

Now, when we try to open the file, it will ask for a password. Type the password and click on OK button.