Protect Sheet
- File › Info › Protect
Locks the cells of the current sheet so their contents cannot be changed, and sets what everyone may still do. Use it once the figures are settled and the sheet is being passed around. The password is checked the way Excel checks it: a sheet protected in Excel stays protected here and asks for its own password, and one protected here asks for it in Excel too.
Some things stay off whatever you tick: merging or unmerging cells, data validation, tables, grouping rows and columns, and turning the filter on or off. Deleting rows or columns and sorting need their option and, on top of that, cells that are all unlocked. The full list, family by family, is in the topic “What sheet protection blocks” in the Print, PDF & protection section.
The two selection options decide where you can move. With only Select unlocked cells ticked, clicking a locked cell does nothing, the arrow keys skip locked cells, and Tab and Enter move to the next unlocked cell in reading order — Shift+Tab and Shift+Enter to the previous one — wrapping round from the last to the first, as in a form. With neither ticked there is no active cell, and the arrow keys scroll the sheet.
- If some cells must stay editable, select them, click Format and choose Unlock Cell.
- Click Protect Sheet.
- If you want a password, type it in Password (optional) and type it again in Reenter password to confirm, in the same window.
- Under Allow all users of this worksheet to:, tick what stays allowed among the fifteen options — Select locked cells, Select unlocked cells, Format cells, Format columns, Format rows, Insert columns, Insert rows, Insert hyperlinks, Delete columns, Delete rows, Sort, Use AutoFilter, Use PivotTable & PivotChart, Edit objects, Edit scenarios. The two selections go together: ticking Select locked cells also ticks Select unlocked cells, and clearing that one also clears the other.
- Click OK: the window stays open and still until the protection is written and, if the wait grows longer, shows a spinner with “Protecting…”.
- To remove the protection, click Protect Sheet again: without a password it comes off at once; with one, Unprotect Sheet opens and always asks for it. While the password is being checked the window stays still, with “Verifying the password…” if the wait grows longer; if it is wrong, the window stays open with “The password is incorrect. Try again.” and you can correct it there.
Tip While the sheet is protected, the commands the protection doesn't allow are grey: click one to read why and which option would make it available. A gesture without a button that the protection refuses, such as typing into a locked cell, shows Excel's message “The cell or chart you're trying to change is on a protected sheet”. Protection covers one sheet at a time, so repeat it on each sheet that has to be locked.