How to Password Protect Excel: Workbook, Sheet, Online Guide

Spreadsheets often contain sensitive data—project budgets, client lists, payroll figures. If that file lands in the wrong hands, the fallout ranges from awkward to catastrophic. Password-protecting your Excel workbooks and sheets is the most direct way to keep prying eyes off your data, and the good news is you don’t need any special software to do it.

Primary protection method: Encrypt with Password (File > Info) · Sheet-level option: Protect Sheet (Review tab) · Workbook structure lock: Protect Workbook (Review tab) · Supported since: Excel 2007 · Online version available: Microsoft 365 Excel

How do I restrict access to an Excel workbook?

When you need the strongest protection—blocking anyone from opening the file without a credential—full workbook encryption is the answer. This applies to Windows Excel and Microsoft 365 desktop.

Encrypt workbook to open with password

• Open your workbook and select File.
• Click Info in the left sidebar.
• Select Protect Workbook and choose Encrypt with Password.
• Enter a strong, case-sensitive password and confirm it.
• Save the file. The next time anyone tries to open it, they must enter the password.

“Select File > Info > Protect Workbook box and choose Encrypt with Password.”

— Microsoft 365 Life Hacks (Official Microsoft guidance)

Verify password protection

• Close and reopen the file. An encryption prompt should appear immediately.
• If no prompt shows, the encryption step may have failed—repeat the process and confirm you saved the file.

How do I lock an Excel sheet from editing?

Sheet protection is granular: instead of locking the whole file, you control which cells people can edit. This is ideal when collaborators need to view most of the sheet but shouldn’t touch specific formulas or headers.

Protect Sheet via Review tab

• Select the cells users should still be able to edit. Right-click and choose Format Cells.
• Go to the Protection tab and uncheck Locked. Click OK.
• Switch to the Review tab and click Protect Sheet.
• Enter a password and choose which actions are allowed—selecting cells, formatting, inserting columns, and so on.
• Confirm the password and save.

“If you lose them, Excel cannot recover them for you.”

— Microsoft Support (Official Documentation)

Password for unprotection

When you set a password, only those who know it can unprotect the sheet later. Without a password, any user can remove the protection layer.

How to password protect an Excel File and make read only?

Read-only mode discourages accidental changes but doesn’t require a password to edit. Pairing it with workbook protection gives you two .

Mark as Final for read-only

• Go to File > Info and select Protect Workbook.
• Click Mark as Final. Excel displays a yellow banner indicating the file is read-only.
• Users can still click “Edit Anyway” to gain write access—this is a recommendation, not a lock.

Combine with workbook protection

• Use Encrypt with Password for strict access control.
• Add Protect Workbook Structure via the Review tab to prevent adding, hiding, or renaming sheets.

How to put password on Excel file 2007?

Excel 2007 introduced the modern protection interface, and the workflow carries through to Excel 2016, 2019, and Microsoft 365. The steps are nearly identical across these versions.

Steps for Excel 2007 desktop

• Click the Office button (top-left) and choose Prepare.
• Select Encrypt Document.
• Enter and confirm your password. Save the file.

Differences from newer versions

Excel 2010 and later moved the encryption command to File > Info > Protect Workbook > Encrypt with Password. The underlying encryption is the same, so a password-protected file from 2007 opens normally in Excel 365.

Windows 10 compatibility

The encryption method works identically on Windows 10 and Windows 11. No additional software is required.

How to password protect excel online?

Excel for the web (part of Microsoft 365) has meaningful limits on password features. Knowing what works online—and what requires the desktop app—prevents wasted effort.

Microsoft 365 Excel steps

• Open your workbook in Excel for the web.
• The File > Info > Protect Workbook menu exists, but direct password encryption is grayed out.
• You can open and edit files that already have a password set on the desktop version.

“Excel for the web can open and edit workbooks protected by a password. Passwords can’t be added, changed, removed, or recovered from Excel for the web.”

— Microsoft Support (Official Documentation)

Limitations vs desktop

• Cannot add a password to a file directly in Excel online.
• Cannot remove a password from a protected file.
• Cannot recover a password in the browser version.

Workaround: Open in Desktop Excel

In Excel online, click Open in Excel to launch the desktop app. Apply password protection there, save, and the file returns to your OneDrive as an encrypted document that you can view read-only in the browser.

Password protecting Excel on Mac

Mac Excel takes a slightly different path to encryption. The menu structure is familiar but uses its own dialog.

File > Passwords on Mac

• Open your workbook in Excel for Mac.
• Go to File > Passwords.
• Enter a password under Password to open (case-sensitive).
• Confirm the password and click OK.
• Save the file. A lock icon appears in the title bar on protected files.

Removing workbook password protection

When you no longer need encryption, the process reverses cleanly in the desktop versions.

Steps to remove encryption

• Open the encrypted workbook and enter the current password.
• Go to File > Info > Protect Workbook > Encrypt with Password.
• Delete the existing password from the field, leaving it blank.
• Click OK and save the file. The encryption layer is gone.

The implication: once the password field is cleared and the file is saved, the document returns to an unprotected state accessible to anyone who opens it.

Summary

Excel offers three distinct protection layers. Encryption via File > Info > Encrypt with Password is the nuclear option—it blocks file access entirely. Sheet protection through Review > Protect Sheet controls what collaborators can change inside the file. Structure protection prevents anyone from adding or hiding worksheets. Excel online handles protected files as read-only but lacks the ability to apply or remove passwords itself. For users on Mac, the File > Passwords menu achieves the same encryption, with the critical caveat of the 15-character limit.

Related reading: secure online banking access

For added precision in safeguarding your spreadsheets, learn techniques to lock cells in Excel and prevent accidental formula overwrites by collaborators.

Frequently asked questions