Arrow left
Back to guides
Excel Tips

4-Step Easy Guide to Encrypt Excel Files

In this article, you will learn to password-protect Excel workbooks in 4 easy steps.

Workbook encryption in Excel

The ‘Encrypt with Password’ feature in Excel is used to password-protect your entire workbook. This feature is particularly useful if the Excel file contains confidential information.

For example: Highly sensitive information such as salaries of staff can be password-protected using the ‘Encrypt with Password’ feature in Excel.

How to password-protect Excel files? (Easy step-by-step guide)

Step 1: Click on the ‘File’ ribbon in the Excel toolbar

Step 2: Click on ‘Info’, then select ‘Protect Workbook’ and click on ‘Encrypt with Password’

The page you see when you click the “File” button in the toolbar in Excel

Step 3: Enter a password and then re-enter the password

Step 4: Click on ‘OK’

The Excel is now encrypted. To ensure it is password protected, close and reopen the Excel file. If the below pop-up message is displayed, the file is successfully encrypted. 

Pop-up message displayed by Excel when opening encrypted files

Note: Passwords are case-sensitive and cannot be recovered if lost. It is highly recommended to maintain a list of encrypted Excel file names and corresponding passwords in a safe and secure way.

Analyze your live financial data in a snap in Google Sheets

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly. 

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

You can learn about other Excel and Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below