If you're using a computer, you probably have some Microsoft Excel documents on your Mac or PC that you do not want others to find and read.
After all, Excel is used by both regular customers and businesses. Government institutions and millions of other people around the world. The best way to keep this information safe is to learn how to protect an Excel file with a password.
Add a password
Step 2: Click "File," followed by "About."
Step 3: Then click the Protect Workbook button. Select "Encrypt with Password" from the drop-down menu.
Step 4: Excel prompts you for a password. Choose one that is intricate and unique and record it in your password manager.
It is of the utmost importance that you remember or have access to a copy in a safe place, as if you forgot it the Excel file and its recovery will be very difficult.
From now on, whenever you try to open this file, Excel prompts you to enter your new password.
Note: This password only protects this single document, not every Excel document on your PC. If you want all Excel files to have similar protection, you must protect each file individually with a password or display advanced protection features.
If you want to see if an Excel file has password protection, read the article Info tab for the document and look at the Protecting a Workbook section. It will tell you if a password is needed to open it or not.
Now that you have password-protected your most important files, it may be worth adding additional security levels to your system. The easiest way to protect a large number of files is to encrypt them. Fortunately, encryption programs are not hard to find. There are several freeware options, and Windows 10 Professional users have a built-in encryption utility called BitLocker.
Would you like to know more? Here is our crash course guide to encryption and another introduction to hiding files in Windows 10.