Post actualizado el día octubre 24, 2026 by DeiviSanzPlay
Locking a range with a password in Excel isn’t a single button: there are at least four distinct mechanisms, and each one solves a different problem. Choosing the wrong one creates the feeling that «the password doesn’t work,» when in reality the wrong protection was applied.
The four approaches and what each one actually stops
1. Protect sheet (Review → Protect Sheet)
This is the most widely used option and the one that lets you decide what the user can do: select locked cells, apply formatting, insert rows, sort, or filter. By default, all cells are created with the «Locked» checkbox enabled, so protecting the sheet outright locks the entire workbook, not just what you intended. The classic mistake: protecting the sheet before unchecking «Locked» on the data-entry cells, and then the user can’t type anything.
Important: the sheet password can be omitted and the sheet is still protected, without a password. Many people don’t know this and believe that without a password there’s no protection.
2. Protect workbook (structure and windows)
This prevents adding, deleting, hiding, or renaming sheets. It does not prevent editing cells. It’s often confused with the previous option: whoever wants to keep anyone from touching a specific sheet doesn’t need this option, and whoever enables it to «protect the data» is surprised to find that the cells remain editable.
3. Password encryption to open (Save As → Tools → General Options)
Here the password encrypts the entire file: without it, the file won’t open, not even to read. It’s the only one of the four that offers real encryption of the content, according to Microsoft’s official documentation. The trade-off: if it’s lost, there’s no practical recovery; modern encryption (128-bit AES in recent versions) isn’t broken by free utilities.
4. Range protection with «Allow Edit Ranges»
This lets you designate editable areas with or without their own password while the rest of the sheet remains protected. Useful in shared templates: the person filling it in writes in their area, and the rest stays intact. Real limitation: it doesn’t prevent copying the content of protected cells to another workbook.
Practical comparison
| Option | Does it encrypt the file? | Does it prevent editing cells? | Can it be bypassed with third-party tools? |
|---|---|---|---|
| Protect sheet | No | Yes, depending on permissions | Yes, relatively easily |
| Protect workbook | No | No | Yes |
| Password to open | Yes | Not applicable | Not practically |
| Editable ranges | No | Partially | Yes |
What experience teaches and the documentation doesn’t shout about
In workbooks with many formulas and cross-references, protecting the sheet can break calculations if the user needs to insert rows: insertion is allowed, but formulas that point to fixed ranges stop updating as expected. This happens in budget templates with SUM referencing specific rows; the symptom is a total that falls short after adding a line. The solution is to convert the ranges into tables before protecting.
Another common case: protecting the sheet with a strong password and forgetting that macros (VBA) can unprotect it if the project isn’t itself protected. In shared office environments, the sheet password stops the casual user, not the knowledgeable curious one.
Which option to choose depending on the scenario
- Sharing a data-entry template: protect sheet + unlock only the input cells + editable ranges if there are several people.
- Preventing someone from adding or deleting tabs: protect workbook.
- Sensitive information (payroll, customer data): password to open, and consider saving in encrypted format outside of email. Here sheet protection provides no confidentiality.
- Teamwork within Microsoft 365: sheet protection coexists poorly with co-authoring in some scenarios; it’s worth testing before rolling out the template to the whole department.
Warnings worth accepting
No sheet or workbook password protects against content extraction: it can be copied to another file. Nor is there any guarantee of full compatibility across desktop, web, and mobile versions; some protection options behave differently in Excel for the web and can prevent editing of areas that were editable on desktop. If the file is going to circulate across several platforms, it’s worth testing the chosen combination on each one before sending it.
Lastly, use your organization’s password manager for the opening passwords: they’re the only ones that, if lost, leave the file inaccessible. Sheet passwords can be removed with tools, but encryption passwords cannot.
