Step 1: In Excel, open the document you want to secure with a password.
Step 2: Click File, followed by Info.
Step 3: Next, click the Protect Workbook button. From the drop-down menu, select Encrypt with Password.
Step 4: Excel will then prompt you to type in a password. Pick one that’s complicated and unique and note it down in your password manager.
It is paramount that you remember it, or have access to a copy of it in a secure location because if you forget it, you will lose access to the Excel file and recovering it will be complicated.
From now on, any time you try to open that file, Excel will prompt you to input your newly chosen password. Note that this password only protects that individual document, not every Excel document on your PC. If you want all Excel files to have similar protection, you’ll need to password-protect each file individually or look at more advanced protections.
If you want to see whether an Excel file has password protection or not, check out the Info tab for the document and look at the Protect Workbook section. It will tell you whether a password is required to open it or not.
Excel also allows you to apply more customized security options to your file if necessary. It’s important to know what these other options do so you can create the right security for your project. Under Protect Document, you’ll find several additional features that may prove useful.