Excel Protect Sheet Without a Password: What Works

Yes. In Excel for Microsoft 365 on Windows, choose Review > Protect Sheet, set the permissions you want, leave the password box blank, and select OK. The sheet is then protected against ordinary edits, but anyone can remove that protection without entering a password.

This is useful when you want to prevent accidental changes rather than restrict access. It is not a way to recover a forgotten password, and it does not encrypt the workbook or make its contents confidential.

How to protect a sheet with a blank password

Use these steps in the desktop version of Excel for Microsoft 365 on Windows:

Open the worksheet you want to protect. Sheet protection is applied to one worksheet at a time.
Open the Review tab and select Protect Sheet.
In the dialog, leave the password field empty. Choose which actions users are allowed to perform while protection is on.
Select OK. Because you did not enter a password, Excel does not require a password confirmation.

The sheet is now protected, and the Review command changes to Unprotect Sheet. To turn protection off, select that command. Excel should remove the protection immediately because no password was set.

In Excel for Mac, the corresponding command is also on the Review tab; select Protect Sheet and leave the password blank. The dialog’s layout can differ slightly by version. Excel for the web has its own Review controls, and the available protection options can differ from the desktop app, so check the commands shown in your version.

What sheet protection actually does

Worksheet protection controls what people can change through Excel’s normal interface. For example, it can stop a user from replacing a formula or changing a label while still allowing them to select cells, use a filter, or enter values in designated input cells. The exact permitted actions depend on the options selected in the Protect Sheet dialog.

Protection does not automatically make every cell uneditable in every situation. Excel cells are generally marked as locked by default, but the Locked setting only takes effect after you protect the worksheet. A protected worksheet therefore combines two things: the locked or unlocked status of individual cells, and the sheet-level protection command.

For a simple example, imagine a budget template with formulas in column D and user-entered amounts in column C. You could keep the formula cells locked, unlock the input cells, and then protect the sheet. Users can fill in amounts while being less likely to overwrite the calculations.

Choose which cells users can edit

If you want a protected sheet to remain useful, decide which cells should stay editable before you turn protection on. To unlock a range in Windows, select the cells, press Ctrl+1 to open Format Cells, open the Protection tab, clear Locked, and select OK. On a Mac, Command+1 opens Format Cells. Then protect the sheet using the blank-password steps above.

For a form, you might unlock only the cells where someone should type, such as B3:B10, while leaving headings and calculation cells locked. When protecting the sheet, allow selection of unlocked cells so users can move among the input fields. You can also allow other actions, such as formatting cells or using AutoFilter, if they are appropriate for the worksheet.

Input cells: unlock cells meant for data entry.
Formula cells: leave them locked if users should not replace formulas.
Allowed actions: enable only the operations people need, such as sorting or filtering.

Try the finished sheet as a user would: click an input cell, enter a test value, and try changing a formula cell. If the result is not what you intended, unprotect the sheet, adjust the cell settings or permissions, and protect it again.

Protection without a password versus protection with one

A blank password is a convenience setting, not a secret. It makes Excel enforce the sheet’s chosen restrictions until someone explicitly selects Unprotect Sheet, but it does not ask that person to prove they are authorized. This can be enough for a shared template where the goal is to avoid casual or accidental edits.

Adding a password changes who can remove the sheet protection through Excel: the person unprotecting the sheet must provide that password. It still does not turn worksheet protection into strong information security. Microsoft describes worksheet protection as a feature for preventing changes to cells, not as a security feature for protecting sensitive information.

Also distinguish sheet protection from a password used to open or encrypt a workbook. A password to open an encrypted file protects access to the file itself. Sheet protection concerns editing a worksheet after the workbook is open. Protecting one worksheet, even with a password, is not a substitute for encrypting a file that contains confidential data.

How to remove passwordless protection

If the sheet was protected with an empty password, removal is straightforward. Open the worksheet, go to Review > Unprotect Sheet, and select the command. Excel should not ask for a password. The cells’ Locked settings remain in place, but they no longer restrict editing until the sheet is protected again.

Removing protection does not erase formulas, values, or formatting. It changes whether Excel enforces the sheet’s restrictions. If you intend to edit the template, you can make the changes and then protect the sheet again, either with a blank password or with a password if a stronger editing barrier is needed.

If you forgot a sheet-protection password

A forgotten password is different from a blank password. If Excel asks for a password when you choose Unprotect Sheet, the sheet was protected with one. Excel does not provide a built-in command that reveals or resets a forgotten worksheet-protection password. The workbook may still open and show its contents, but changing protected cells can be blocked.

Start with legitimate recovery options that preserve the workbook and its data:

Ask the person or team that created the workbook for the password or an editable copy.
Check your organization’s approved document storage, notes, or password manager for the recorded password.
If the file is stored in OneDrive or SharePoint, review available version history for an earlier version that was not protected.
Look for the original source file, an unprotected template, or a separate export of the data.

Make a copy before attempting any recovery process. Be wary of websites or downloads that promise instant password removal: they may expose confidential workbook contents, install unwanted software, or produce a damaged file. A sheet-protection password should not be confused with a password that encrypts the file; if the workbook cannot be opened because it is encrypted, the recovery problem is different.

Limits and common misconceptions

One common misconception is that a protected sheet cannot be copied or viewed. Sheet protection is mainly about restricting worksheet changes, not concealing its contents. Depending on the permissions and workbook setup, people may still be able to read or copy visible data. Do not use it to hide private information from someone who can open the workbook.

Another misconception is that protecting a sheet protects the whole workbook. Workbook-structure protection is a separate command, intended to restrict changes such as adding, deleting, moving, or renaming sheets. It does not replace worksheet protection, and neither option is the same as file encryption. Choose the feature that matches the problem you are trying to prevent.

Finally, restrictions can affect ordinary work in ways that surprise users. For instance, a locked formula cell cannot be changed while protection is on, even if someone needs to correct it. Before distributing a protected template, test data entry, navigation, filtering, and any other actions your users need. Keep an editable master copy in a controlled location.

When passwordless protection is a good fit

Use a blank password when your main concern is accidental editing and it is acceptable for a user to remove protection deliberately. Examples include a classroom exercise, a team input form, a reusable report layout, or a worksheet with formulas that should not be overwritten during routine use.

Use a password or another access-control measure when only authorized people should be able to change the sheet. If the information itself must be kept from unauthorized readers, control access to the file and consider workbook encryption rather than relying on sheet protection. In a workplace, follow the organization’s storage and sharing policies, since a file can be copied or shared beyond the worksheet’s controls.

Frequently Asked Questions

Can I protect an Excel sheet without entering a password?
Yes. Select Review > Protect Sheet, leave the password field blank, choose the allowed actions, and select OK. Excel will enforce the selected sheet restrictions until someone removes them.

Can anyone unprotect a sheet with no password?
Yes. Anyone who can open the workbook and use the worksheet controls can select Review > Unprotect Sheet. A blank password does not verify a user’s identity.

Does protecting a sheet hide its data?
No. Sheet protection is for limiting edits, not for making worksheet contents confidential. Use appropriate file access controls and encryption when you need to protect access to the workbook.

Why can I still edit some cells on a protected sheet?
Those cells may have been unlocked before sheet protection was enabled, or the action may be permitted by the protection settings. Check the cells’ Locked setting and the allowed actions in the Protect Sheet dialog.

What if Excel asks for a password when I unprotect the sheet?
That indicates a password was set; it is not a blank-password-protected sheet. Ask the workbook owner, check approved records or version history, and avoid untrusted password-removal services.

Bottom line

Excel can protect a worksheet without a password: leave the password field empty when you select Review > Protect Sheet. This is a practical safeguard against accidental edits, especially when you unlock only the cells intended for data entry. Anyone can remove that protection, however, so use encryption and access controls—not passwordless sheet protection—when confidentiality matters.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.