how to make excel file password protected

This password protection will restrict all users from moving, hiding, renaming, or deleting any worksheets in a workbook file. We can equally use different workbook-level protection. Our workbook is now successfully unprotected.įigure 8 – Unprotect workbook How to password protect excel files

Next, we will clear out the password and click OK.

To remove the password, we will go back to info, select Password Workbook followed by Encrypt with Password.

When we save and close file, anyone who tries opening it will receive the prompt below requesting for the password.

We will receive a prompt to re-enter the password and then click OKįigure 5 – How to add a password to an Excel file.

In the Encrypt Document dialog box, we will enter the password we wish to use in password protecting workbook and select OKįigure 4 – How to password protect an Excel file.

Next, we will choose Encrypt with password from the drop-down menuįigure 3 – How to password protect a spreadsheet.

We will go to the File Tab and select Protect Workbook in the Info section.įigure 2 – How to password protect an Excel workbook.

First, we will make sure that all the changes in our Excel file have been saved.

In this case, adding this protection restricts other users from opening the file. This is called workbook-level protection. In this tutorial, we will explore easy ways to protect and password protect an Excel file.įigure 1 – How to create a password for Excel file How to Protect a Workbook or Excel file We can equally password protect our Excel file to ensure that we have adequate control over the data. This is very important if we have to move or share our data so that it retains its structure without modifications.

We can secure or protect our excel workbooks in many ways.

How to make excel file password protected