How to password protect an Excel file - KSTC-TV, Channel 45 Lifestyle-

How to password protect an Excel file

Posted:
By Jon Martindale


Content Provided by  

If you use a computer, you probably have some Microsoft Excel documents on your Mac or PC that you wouldn’t want other people to find and read.

After all, Excel is used by both regular consumers, businesses, government institutions, and millions of other folks all over the world. Whether you are creating graphs, converting PDFs, or just inputting rows and rows of data, here are the best way to keep that information safe is to learn how to password protect an Excel file.

Adding a password

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, then select “Encrypt with Password.”

Mark Coppock/Digital Trends

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, as if you forget it, you will lose access to the Excel file and recovering it will be very difficult.

Mark Coppock/Digital Trends

From now on, any time you try to open that file, Excel will prompt you to input your newly chosen password.

Note: 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.

Now that you’ve password protected your most important files, it might be worth considering adding extra layers of security to your system. The easiest way to protect a large number of files is to encrypt them. Luckily, encryption programs are not hard to find. Windows 10 Professional users have a built-in encryption utility called Bitlocker, but if you want to download a free version with lots of customization options for many types of data, you can try Crypto Expert 8 or VeraCrypt open source downloads.

Additional security options

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 several additional features, which may prove useful:

Mark as Final: This will mark the file as completed, which lets other people know that they shouldn’t make any changes. This will not secure the file behind a password, however, so it doesn’t really offer any security.

Protect Current Sheet: This will guard the currently selected worksheet with a password so that people can’t make any changes. It’s a handy option if there’s only one sheet in the workbook that you want to protect, and you don’t mind if people can see the info—you just don’t want them messing with anything. You will notice that there’s also an option to do this with “Workbook Structure” which protect data throughout the workbook from changes unless people have the password.

Restrict Access: Restrict access is an interesting option used by organizations where IT has created security templates that essentially lock Excel files to only certain people or ranks. It’s handy in larger organizations where some people should be able to access the file, but not everyone.

Add a Digital Signature: This simply verifies the file as the real version, which is useful when sending it to other people or organizations, and when making sure it hasn’t been altered. It also helps files from being spied on when you send them digitally.

Want to learn more about it? Here’s our crash course guide to encryption, and another on how to get started with hiding files in Windows 10.


  helps readers keep tabs on the fast-paced world of tech with all the latest news, fun product reviews, insightful editorials, and one-of-a-kind sneak peeks.

Powered by Frankly
All content © Copyright 2000 - 2014 WorldNow, Hubbard Broadcasting, Inc., and KSTC. All Rights Reserved.
For more information on this site, please read our Privacy Policy and Terms of Service.