Excel Protect Sheet Shortcut: Windows Steps and Options

In Excel for Microsoft 365 on Windows, press Alt, then H, O, and P in sequence to open Protect Sheet. Choose the actions users may perform, optionally enter a password, and confirm; sheet protection takes effect after you finish the dialog.

The Windows shortcut and what it opens

Alt+H, O, P is a sequence of ribbon access keys, not a three-key chord. Press and release Alt, then press H, O, and P one at a time. The sequence follows the Home tab, the Format menu, and Protect Sheet. If you hold all the keys together, or type them before Excel displays the next set of Key Tips, it may not work as intended.

The shortcut opens the Protect Sheet dialog; it does not instantly lock the worksheet or create a password. The dialog lets you set permissions and, if you choose, a password. Once you confirm those choices, Excel applies protection to the active sheet. If the sequence is unavailable because the ribbon is customized or the application is localized, use the ribbon path Review > Protect Sheet or Home > Format > Protect Sheet.

Make sure the correct worksheet is active before you start. Protection is applied to the current sheet, not automatically to every sheet in the workbook. If you have several sheets to protect, repeat the process for each one and review each sheet’s settings separately.

Protect a worksheet step by step

Select the worksheet tab you want to protect. Check the tab name, especially if the workbook contains similarly named sheets.
Press Alt, H, O, P in sequence, or select Review > Protect Sheet.
In the dialog, decide which actions should remain available. The standard options include selecting locked or unlocked cells, formatting cells or columns, inserting or deleting rows, sorting, and using AutoFilter.
If appropriate, enter a password in the password field. You can also leave it blank; a password is not required to turn on worksheet protection.
Select OK. If you entered a password, Excel asks you to enter it again to confirm. Type it carefully and confirm.
Test the sheet by trying an allowed action and a change you meant to prevent. This can reveal a permission choice that does not match your intent.

For example, imagine a budget sheet where people should enter monthly amounts in cells D5:D16 but should not change the formulas in E5:E16. Unlock the input cells first, leave the formula cells locked, and then protect the sheet while allowing selection of unlocked cells. Protection settings govern what people can do after protection is enabled; they do not automatically identify which cells are intended as inputs.

How locked cells and permissions work

Excel marks cells as locked by default, but that setting does not stop editing on its own. A cell’s Locked property becomes effective only after you protect the worksheet. This distinction explains why locking a cell in Format Cells may seem to do nothing until sheet protection is turned on.

To make selected cells editable, select them, open Format Cells with Ctrl+1, choose the Protection tab, clear Locked, and select OK. Then protect the sheet. People can edit unlocked cells while the locked cells are protected. The locked status is a cell-format setting, so you can prepare a sheet’s input and formula areas before enabling protection.

The checkboxes in Protect Sheet define the permitted actions. Allowing users to select cells is different from allowing them to edit locked cells: selection alone does not grant permission to change a protected cell. Consider the tasks people genuinely need, rather than enabling every option by default. For a simple form, allowing selection of unlocked cells may be enough. A sheet designed for filtering or formatting will need additional permissions.

Selection: Allow selection of unlocked cells so people can move among input fields. You can also allow selection of locked cells, which may be useful for reading or copying formulas without permitting edits.
Formatting: Allow only the formatting changes users need. Formatting cells, columns, or rows are separate choices in the dialog.
Rows and columns: Inserting or deleting rows and columns can affect formulas and layout, so enable these actions only when the sheet is designed to accommodate them.
Sorting and filtering: Enable the relevant options if people need to sort data or use existing filter controls. Protected-sheet rules can limit sorting when the affected cells are locked, so test the actual range and workflow.

What sheet protection does—and does not do

Worksheet protection is mainly a way to prevent accidental edits and guide how a sheet is used. It can help preserve formulas, labels, and layout while leaving designated entry cells available. It is useful for templates, shared trackers, and forms where a clear boundary between inputs and calculations reduces mistakes.

It is not the same as securing the workbook with encryption. Sheet protection is not intended to keep a determined person from accessing sensitive information or to provide strong confidentiality. Do not rely on it to conceal private data. If you need to prevent people from opening a file without authorization, use file-level encryption and follow your organization’s storage and sharing policies. In Microsoft 365 for Windows, the file-encryption option is under File > Info > Protect Workbook > Encrypt with Password; that protects access to the workbook file, not just editing on one sheet.

Workbook structure protection is another separate feature. It can restrict actions such as adding, deleting, moving, hiding, or renaming sheets, depending on the protection settings. Protecting a sheet does not automatically protect the workbook’s structure, and protecting the structure does not automatically protect the cells on each sheet. Choose the feature that matches the change you want to prevent.

Removing protection and handling passwords

To remove protection from the active sheet, use Review > Unprotect Sheet. If a password was set, Excel asks for it before removing protection. The Home-tab route may also show Unprotect Sheet in the Format menu while the sheet is protected. The command’s label changes with the sheet’s current state.

A password is optional, but it adds a practical barrier against casual changes to the protection setting. It does not turn worksheet protection into strong file security. If you use one, store it in an approved password manager or another secure location and make sure the people responsible for maintaining the workbook can retrieve it. Excel does not provide a normal “show me the forgotten sheet password” command, so losing it can complicate legitimate maintenance.

Before distributing a protected workbook, keep an unprotected working copy in a controlled location if that suits your organization’s process. Also test the copy that users will receive. A sheet can be protected successfully yet still frustrate users if an input cell remained locked, or if a needed filter or formatting permission was not enabled.

Differences on Mac and in Excel for the web

The Alt-based access-key sequence described above is for Excel on Windows. On a Mac, use the Review tab and choose Protect Sheet; the Windows sequence is not the Mac equivalent. Mac keyboard shortcuts and ribbon behavior can also depend on the keyboard and macOS settings, so the visible ribbon command is the clearest route if you do not have a shortcut configured.

In Excel for the web, open the workbook in a browser and look for Review > Protect Sheet. The web interface and available controls can differ from the Windows desktop dialog, and some workbook-management tasks may be easier in the desktop application. If a command is missing or a protection workflow behaves differently, check whether the file is open in the browser or in the desktop app before troubleshooting the worksheet itself.

These differences matter when sharing instructions with a team. A Windows user can follow Alt, H, O, P, while a Mac or browser user should follow the appropriate ribbon command. Avoid describing the Windows key sequence as a universal Excel shortcut.

Common problems and practical checks

The shortcut does nothing: Confirm that you are using desktop Excel on Windows and pressing the keys in order, not simultaneously. If Key Tips do not appear or the sequence differs, use Review > Protect Sheet.
People can still edit a cell: Check whether that cell is unlocked, whether the sheet is actually protected, and whether the change is permitted by another setting. A locked cell is not protected until sheet protection is enabled.
People cannot enter data: The input cells may still be locked. Unprotect the sheet, unlock the intended entry cells through Format Cells, and protect the sheet again.
Filtering or sorting is blocked: Review the corresponding permission in the Protect Sheet dialog and test with the real data range. Protection can interact with locked cells and the arrangement of a sort range, so checking only the checkbox may not be enough.
The wrong sheet was protected: Unprotect the active sheet if necessary, select the intended sheet tab, and repeat. Each sheet has its own protection state.
Users can change formulas by pasting: Test common user actions, including pasting, on a copy of the workbook. Design protection around the actual workflow, and keep formulas locked while making only the required input areas editable.

For an important template, make a duplicate before changing protection settings. Work through the normal user journey on that duplicate: enter a value, navigate between fields, apply any required filter, and confirm that formulas and headings cannot be changed. A short practical test is more reliable than assuming that a particular combination of checkboxes will suit every layout.

Frequently Asked Questions

What is the keyboard shortcut to protect a sheet in Excel?
In Excel for Microsoft 365 on Windows, press Alt, H, O, P one key at a time. It opens the Protect Sheet dialog; you still need to choose permissions and confirm the settings.

Can I protect a sheet without a password?
Yes. Leave the password field blank and confirm the dialog. The sheet is still protected against actions not allowed by the selected permissions, although users may be able to remove protection without entering a password.

How do I protect only certain cells?
Unlock the cells people should edit, leave the other cells locked, and then protect the worksheet. Since cells are generally marked locked by default, the key step is unlocking the intended input cells before enabling protection.

Is Protect Sheet the same as Protect Workbook?
No. Protect Sheet controls permitted actions on one worksheet. Protect Workbook can refer to workbook-structure protection or file encryption, which serve different purposes. Choose the command according to whether you want to restrict sheet edits, structural changes, or access to the file.

Does the Windows shortcut work in Excel for Mac?
No; Alt, H, O, P is the Windows ribbon access-key sequence. On a Mac, use the Review tab and select Protect Sheet. Excel for the web also has its own ribbon interface, usually through Review > Protect Sheet.

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.