How to Lock Down Parts of a SharePoint File
Sometimes you need to share a document but protect specific sections — pricing in a proposal, formulas in a template, signatures in a form. SharePoint can’t do this alone, but Word and Excel can.
What it is
Permission models work at the file level: someone has access or they don’t, can edit or can’t. Within a single file, you can share with edit access but still want to protect specific sections — a header, a formula, a signature block, a table of fixed prices. This is where Word and Excel’s built-in protection features come in.
In Word, you can mark sections as restricted while leaving others open. In Excel, you can protect specific cells, formulas, or sheets while permitting edits elsewhere. These are document-level controls, separate from SharePoint permissions, but they layer cleanly on top.
The protection isn’t unbreakable — a determined user with full access could remove it — but it prevents accidental damage and signals intent clearly. For most collaboration, that’s enough.
When to use this
- Templates where users should fill in fields but not change structure.
- Forms with protected sections (signatures, calculations).
- Documents with mixed sensitivity (some sections collaborative, others fixed).
- Spreadsheets with formulas users shouldn’t accidentally overwrite.
How to do it
- In Word: Use Review > Restrict Editing to limit changes to specific sections.
- In Excel: Use Review > Protect Sheet (with optional password) to lock specific cells while permitting edits in others.
- Choose what users can and can’t do.
- Save the file with protection enabled.
- Share via SharePoint as normal — the document-level protection persists.
- Test as a different user to confirm the protection works as intended.
Best practices
- Use document-level protection sparingly. Most files don’t need it; over-use creates friction.
- Combine with SharePoint permissions. Layered controls are more effective than single ones.
- Document protections and passwords. If you set a password, store it somewhere others can find when needed.
- Consider templates and content controls. For repeatable forms, content controls in Word are cleaner than restriction.
Common mistakes
- Relying on document protection for security. It’s about preventing accidents, not preventing determined users.
- Setting passwords nobody else knows. When the original owner leaves, the file becomes unmaintainable.
- Over-protecting collaborative documents. If users can’t easily contribute, they’ll find workarounds — usually worse than the original.
The Sharing Handbook gives you the Traffic Light System for every SharePoint sharing decision. Real screenshots of the Link Settings dialog, end-user focused, no admin access required.
Get the Sharing Handbook — $27 →FAQ
Can I lock part of a Word document in SharePoint?
Yes — in Word, use Review → Restrict Editing to mark sections as editable only by specific people or to limit editing to comments. When you save the file to SharePoint, the restrictions travel with the document. Anyone opening the file in Word for the web or desktop sees the same restrictions enforced.
How do I lock cells in an Excel file in SharePoint?
In Excel, select the cells you want to keep editable, right-click → Format Cells → Protection, uncheck Locked. Then go to Review → Protect Sheet to lock everything else. Save to SharePoint. Users can only edit the cells you left unlocked. Add a sheet password for stricter enforcement.
Can sensitivity labels lock parts of a SharePoint file?
Sensitivity labels can apply encryption and restrictions to the whole file (e.g. ‘view-only for external users’) but don’t selectively lock parts of the document. For partial protection, combine a sensitivity label (file-level) with Office’s section restrictions (content-level) — they coexist and reinforce each other.
Why are my SharePoint file restrictions being ignored?
Three causes: the file was saved as a different format (e.g. .docx → .pdf) that strips restrictions; the user has full edit access via SharePoint permissions and the file’s Office restrictions are bypassable for owners; or the restriction was set in Word but the user is editing in Word for the web (which has fewer restriction features). Test in both desktop and web before relying on this.