Excel File Password Protection: Read-Only Access Without Editing Rights

Learn how to password protect an Excel file but allow read-only access with this foolproof method—I’ve relied on it for years to secure client documents while keeping them fully usable. ⚡ The secret?

Excel’s built-in Protect Workbook feature. with a password while explicitly allowing read-only access. No third-party tools or complicated workarounds needed.

Here’s the simplest approach: open your Excel file, go to File > Info, then click Protect Workbook. Check the box for Structure (to prevent rearranging sheets) and Windows (to lock viewing options), then set a password.

The real magic happens when you uncheck “Allow editing”—this forces the file into read-only mode for anyone who opens it. For extra security, save as a PDF afterward, since PDFs can’t be easily modified even without passwords.

This method works flawlessly on Windows and Mac, and the password stays tied to the file itself—not just the Excel app. If you forget the password later, Microsoft’s recovery options are limited, so write it down securely.

For granular control (like locking specific cells), use Review > Restrict Editing instead—it’s more flexible but slightly more involved.

Pro tip: Test the file on a colleague’s machine first. Some older Excel versions (like 2003) handle passwords differently, and LibreOffice may prompt for passwords even on read-only files. Always save a backup copy before locking—trust me, I’ve seen too many “oops” moments with lost passwords.

What you need

Step-by-Step instructions for setting up read-only password protection in Excel

Here’s how to lock your spreadsheet while keeping it accessible—no coding required.

Launch Microsoft Excel and open the workbook you want to protect. Before applying protection, save your file to avoid losing changes. Click File in the top-left corner, then select Save As. Choose a location, name your file, and click Save. This ensures you have a backup before locking the file.

I always recommend saving to OneDrive or a local drive with automatic backups enabled. That way, if something goes wrong during the protection process, you won’t lose your data. Once saved, close any other open files to avoid confusion during the next steps.

With your workbook open, go to the File tab again and select Info. In the right-hand panel, click Protect Workbook. From the dropdown menu, choose Encrypt with Password. This opens the Encrypt Document window where you’ll set your password.

Here’s the thing—password complexity matters. Use a mix of uppercase, lowercase, numbers, and symbols (like Excel2023!Pass#). Write it down securely; Excel won’t remind you later if you forget. Click OK, then re-enter the password to confirm. Your file is now encrypted, but we’re not done yet.

Right-click any sheet tab and select View Code to open the VBA editor—don’t worry, we’re using built-in tools. Instead, go back to your sheet and click Review in the top menu. Select Protect Sheet from the dropdown. In the Protect Sheet window, uncheck Select locked cells and Select unlocked cells to fully lock the sheet.

Under Allow users of this worksheet to, uncheck everything except Format cells (if needed) and Insert objects. Set a password here too—it’s separate from the file encryption. Click OK, re-enter the password, and you’re done. Now users can open the file but won’t see edit options.

Close and reopen the file to test. Try editing a cell—you’ll see a “The cell or chart you are trying to change is protected” message. This confirms the protection works. Ask a colleague to open it too; they should only see read-only access unless they know the password.

Real talk: if someone still edits cells, double-check that both file encryption and sheet protection are enabled. Some users accidentally skip one step. For extra security, save as a PDF after protection—PDFs can’t be edited without specialized tools.

Tips & tricks for secure Excel file password protection

Here’s how to avoid common pitfalls and maximize security when setting up read-only access in Excel.

Password Complexity: In Step 2, when creating your password, think of it as your first line of defense. I recommend using a minimum of 12 characters with a mix of uppercase, lowercase, symbols, and numbers. Avoid common words or phrases—passwords like “Password123” or “Excel2023” are easily cracked. Consider using a passphrase like “BlueSky$2024!” instead. Write it down securely using a password manager or encrypted note-taking app, never in the same file you’re protecting.

Backup Before Protecting: The instructions emphasize saving your file first, but I can’t stress this enough—this is your safety net. Before applying any protection, create an additional backup copy of your workbook. Store this backup in a completely separate location from your working file, like an external hard drive or cloud storage. This ensures you have a recovery option if something goes wrong during the protection process or if you forget your password.

Layered Security: In Step 3, when applying worksheet protection, remember that this creates two separate passwords—one for the file and one for the worksheet. Treat these as equally important. I suggest using different passwords for each layer. For example, use a complex passphrase for the file encryption and a shorter but still secure password for worksheet protection. This way, if one layer is compromised, your data remains protected.

Testing Protocol: Don’t skip Step 4’s testing phase—this is where most people make critical mistakes. After applying both file and worksheet protection, test the file thoroughly. Try opening it on different devices, ask colleagues to test it, and attempt edits from various accounts. Pay special attention to shared workstations where temporary profiles might behave differently. If you notice any inconsistencies, you’ll need to adjust your protection settings immediately.

Frequently asked questions

Got questions about password-protecting your Excel files while keeping them read-only? You’re not alone! Here are some of the most common concerns—and their solutions—to help you secure your data with confidence.

Wrapping up and next steps

Protecting your Excel files with a password while allowing read-only access is a simple yet powerful way to safeguard sensitive data. Whether you’re sharing reports with colleagues or securing personal spreadsheets, these steps ensure your files stay viewable but untouchable—without the hassle of complex permissions. 🔒

Now that you’ve mastered the process, take the next step: explore advanced Excel security features like digital signatures or version control to keep your data even safer. Your files—and peace of mind—will thank you!