# Password-protect your Excel files Generally, there are two ways to protect your files by adding a password to Excel: you can **protect the whole Excel file** from unauthorized access or you can protect select **Excel sheets** or even individual cells from unwanted changes. With the first option, the entire file is encrypted and can only be opened by entering the password. With the second option, the password serves as read-only protection to ensure that data and content aren’t manipulated or accidentally edited. This doesn’t protect the file from being viewed by others. We'll show you how to set up both. ## Password protection for the whole Excel file in just a few steps The steps below detail how you can **password-protect an Excel file** so that it can only be opened by people who know the password. **Quick start guide: Add a password to an Excel file** 1. From the “File” menu access “Info” > “Protect Workbook” > “Encrypt with Password”. 2. Choose a secure password. 3. Repeat your chosen password to confirm the selection. **Step 1**: To get started password-protecting your select Excel file, click on “File” and then “Info” in Excel. Then click on “Protect Workbook” and select “**Encrypt with Password**”. [![Image: Overview of “File” > “Info” > “Protect Workbook” menu](https://www.ionos.ca/digitalguide/fileadmin/_processed_/e/3/csm_overview-of-file-info-protect-workbook-menu_f4cf21744a.webp "Overview of “File” > “Info” > “Protect Workbook” menu") The options for protecting the entire workbook can be found in the Info menu of your Excel file. ](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2022/overview-of-file-info-protect-workbook-menu.png) **Step 2**: You’ll be prompted to provide a password for your document. **Choose a secure password** and store it in a suitable place. You can use a [password manager](https://www.ionos.ca/digitalguide/server/security/password-managers-an-overview-of-todays-best-tools/ "Password managers: an overview of today’s best tools") to make it easier to manage multiple passwords. A warning pops up and this should be taken seriously: without the password, you won’t be able to access the content of your Excel file later. Make sure you don’t accidentally switch on capitalization (Caps Lock) on your keyboard. [![Image: Screenshot of the “Encrypt Document” window](https://www.ionos.ca/digitalguide/fileadmin/_processed_/5/2/csm_screenshot-of-the-encrypt-document-window_f107f02dd5.webp "Screenshot of the “Encrypt Document” window")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2022/screenshot-of-the-encrypt-document-window.png) Enter the password for your file here. Notice the warning! --- ### Note It’s best to refrain from using your wedding date or a pet's name as a password. If **data security** is important to you, choose a [truly secure password](https://www.ionos.ca/digitalguide/server/security/protect-sensitive-data-with-a-strong-password/). --- **Step 3**: You’ll be prompted to **repeat your password to confirm the selection**. Encryption is only completed if the two passwords match. If you make a mistake, you’ll receive a message stating that the two passwords are not identical. Try again or start over. [![Image: “Confirm password” dialog](https://www.ionos.ca/digitalguide/fileadmin/_processed_/0/b/csm_confirm-password-dialog_2baa3fb37b.webp "“Confirm password” dialog")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2022/confirm-password-dialog.png) Confirm your chosen password in the next step. **Result**: Excel advises that this workbook can now only be opened by using the correct password: [![Image: Excel shows that the workbook is now password-protected](https://www.ionos.ca/digitalguide/fileadmin/_processed_/3/e/csm_excel-shows-that-the-workbook-is-now-password-protected_7fc016f96d.webp "Excel shows that the workbook is now password-protected")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2022/excel-shows-that-the-workbook-is-now-password-protected.png) Once the workbook has been successfully password-protected in Excel, a notice is displayed in the Info menu. Now, the next time you open the file, you’ll be asked to enter the password. If you’ve selected a suitable password that’s neither too short nor easy to guess, your **file is securely protected**. Even Microsoft couldn’t crack a secure Excel password. But this also means if you forget your password, all contents of your file will be lost. Beware: Protecting an Excel spreadsheet with a password is not the same as [making an Excel file read-only](https://www.ionos.ca/digitalguide/online-marketing/online-sales/how-to-make-excel-file-read-only/ "How to make Excel file read only"). The latter only **prevents editing, not opening a file**, and can be bypassed relatively easily. --- ### Tip Want to password-protect multiple Excel files at the same time and store them in an archive? You can [archive your files in a ZIP-compressed folder](https://www.ionos.ca/digitalguide/server/configuration/create-a-zip-file/) and [encrypt the ZIP file](https://www.ionos.ca/digitalguide/server/security/password-protect-zip-files/). --- ## Password-protect Excel worksheets Instead of password-protecting the entire Excel spreadsheet, you can **encrypt individual worksheets**. However, this is less suitable for privacy and merely prevents inadvertent changes to a worksheet’s content. The access can be controlled down to the level of individual cells. ### Quick start guide: protect Excel worksheets with password 1. To enable editing of select cells, mark the cells, right-click and select “Format cells”. 2. From the “Protection” sub-menu remove the checkmark “Locked” and click on “Ok”. 3. In “Review” select “Protect Sheet”. 4. Choose a password to protect your Excel worksheet. ### Step 1 (optional): Select cells Before activating sheet protection, you can specify individual cells in a sheet that won’t be password-protected so that only certain cells are editable, and the rest aren’t. If you skip this step, all cells in a worksheet will be protected from edits. **Mark the cells you want to remain editable**. Right-click to launch the menu and select “Format Cells”. You can also access cell formatting options by using the [Excel shortcut](https://www.ionos.ca/digitalguide/online-marketing/web-analytics/excel-shortcuts/ "Excel shortcuts") \[Ctrl\] + \[1\]. [![Image: Selected cells in Excel and “Format Cells” menu](https://www.ionos.ca/digitalguide/fileadmin/_processed_/1/1/csm_selected-cells-in-excel-and-format-cells-menu_8d3e18d348.webp "Selected cells in Excel and “Format Cells” menu")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2022/selected-cells-in-excel-and-format-cells-menu.png) Selected cells will remain editable even after you password-protect the worksheet. In the next window, open the “Protection” tab and remove the checkmark next to “Locked” so that the **selected cells aren’t locked** when you protect the Excel worksheet with (or without) a password. [![Image: “Format Cells” menu, “Protection”](https://www.ionos.ca/digitalguide/fileadmin/_processed_/a/a/csm_format-cells-menu-protection_24ae333471.webp "“Format Cells” menu, “Protection”")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2022/format-cells-menu-protection.png) Here you can unlock the selected cells. The changes are only activated once you activate sheet protection in the next step. ### Step 2: Set protection In your sheet, select the “Review” menu and then click on the “Protect Sheet” option. [![Image: Menu: “Review” > “Protect Sheet”](https://www.ionos.ca/digitalguide/fileadmin/_processed_/f/6/csm_menu-review-protect-sheet_0412dd85b1.webp "Menu: “Review” > “Protect Sheet”") Sheet protection is accessible from the “Review” menu in Excel. ](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2022/menu-review-protect-sheet.png) From the dialog, you can manage user options further. By default, sheet protection means that **contents or formatting cannot be amended, added, or removed**. If you want to allow for some changes to be made to a sheet, you can set up the details here. You’ll be asked to **save a password** to remove sheet protection. If you don’t set a password, any user can remove the sheet protection. [![Image: “Protect Sheet” dialog](https://www.ionos.ca/digitalguide/fileadmin/_processed_/8/e/csm_protect-sheet-dialog_6d69a54016.webp "“Protect Sheet” dialog")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2022/protect-sheet-dialog.png) When encrypting sheets, you can specify the changes that will be allowed and those that won’t. **Result**: Now, if you or other users try to enter new data in an encrypted cell, for example adding sales data for Park Lane (see image above), Excel will reject the entry and flag up a message to alert the user that the **sheet is (password) protected**. [![Image: Alert when trying to modify encrypted cells](https://www.ionos.ca/digitalguide/fileadmin/_processed_/3/d/csm_alert-when-trying-to-modify-encrypted-cells_f9e2dbb606.webp "Alert when trying to modify encrypted cells")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2022/alert-when-trying-to-modify-encrypted-cells.png) An alert pops up when trying to modify encrypted cells in Excel. This function is **not intended as a security feature**, but instead prevents unwanted or accidental changes to Excel worksheets. In addition, the sheet’s content and formatting **remains fully visible**. --- ### Note Regardless of workbook or sheet protection, **Excel macros** are not or **only partially activated by default for security reasons**. To use macros you obtained from a reliable source, you’ll need to [activate Excel macros](https://www.ionos.ca/digitalguide/online-marketing/online-sales/enabling-macros-in-excel/). --- ## Removing Excel password-protection After you’ve password-protected individual worksheets or entire Excel files, [you can remove the password-protection](https://www.ionos.ca/digitalguide/online-marketing/online-sales/removing-a-password-in-excel/ "Removing a password in Excel") again just as easily. However, things can get complicated (or even impossible) if you don’t have the correct password to hand. That’s why it’s important to always store your passwords safely. This is a markdown version of: [https://www.ionos.ca/digitalguide/online-marketing/online-sales/password-protect-excel/](https://www.ionos.ca/digitalguide/online-marketing/online-sales/password-protect-excel/) for AI/LLM consumption.