LibreOffice Calc Sheet Protection: Setup, Limits, and Tips

To protect a sheet in LibreOffice Calc, open the sheet and choose Tools > Protect Sheet. You can add a password in the dialog; to let people edit selected cells, first mark those cells as unprotected in Format > Cells > Cell Protection, then turn on sheet protection.

What sheet protection does

Calc sheet protection controls which cells can be changed while protection is active. It is useful for templates, forms, and shared workbooks where some entries should remain fixed—for example, a budget sheet with editable expense amounts but locked headings and totals. It is applied to one sheet at a time, so a workbook with several sheets may need protection configured separately on each one.

A key detail is that a cell’s Protected setting does not, by itself, stop editing. In a new Calc sheet, cells are generally marked as protected by default, but that setting only takes effect after you protect the sheet. Conversely, you can clear the Protected setting for input cells before enabling protection, allowing those cells to remain editable.

Calc may show slightly different dialog wording or layout across versions and interface configurations, but the main desktop command is Tools > Protect Sheet. On macOS, the application menus appear in the system menu bar; the command is still under Tools in standard Calc menus.

Protect a sheet step by step

Open the sheet you want to protect. Review it first and decide which cells should remain editable.
Select the cells that users should be able to change. For non-adjacent ranges, hold Ctrl while selecting additional ranges on Windows or Linux; on macOS, use Command where the interface calls for the platform’s modifier key.
Choose Format > Cells, then open the Cell Protection tab. Clear the Protected checkbox and confirm the change. These cells are now marked as editable once sheet protection is enabled.
Choose Tools > Protect Sheet. Enter a password if you want to require one to remove protection, and enter it again to confirm when prompted. If the dialog offers options for selecting protected or unprotected cells, choose the behavior appropriate for your form.
Confirm the dialog and test the sheet. Try changing a locked heading or formula cell, then try entering a value in an unlocked input cell. This catches setup mistakes before you share the file.

If every cell should be read-only, skip the cell-unlocking steps and protect the sheet. If the Tools menu command is unavailable, check whether the sheet is already protected or whether the file is open in a mode that does not permit changes.

Choose which cells remain editable

For a practical form, make only the entry fields unprotected. Suppose a service log has dates in column A, staff names in column B, and notes in column C. If users should enter names and notes but not alter the date headings or the layout, select the intended entry cells in columns B and C, clear Protected for those cells, then protect the sheet. The exact rows depend on the form; avoid unlocking entire columns if users only need a fixed set of rows.

Consider using separate ranges for different kinds of input. For example, a checklist might have editable status cells but locked task descriptions. Label editable areas clearly, and use cell formatting, borders, or instructional text to show where users should type. Protection prevents accidental changes; clear design reduces accidental changes in the first place.

Locked cells: Keep headings, instructions, formulas, and fixed reference values protected.
Unlocked cells: Allow editing only in intended input fields.
Test cases: Check ordinary typing, pasting, and any needed operations such as sorting or filtering. A protected sheet may restrict actions beyond typing into locked cells, depending on the operation and configuration.

To change the arrangement later, remove sheet protection first, adjust the Protected setting through Format > Cells > Cell Protection, and protect the sheet again.

Using a password and removing protection

A password is optional, but it makes it harder for a casual user to switch off protection. Choose one that is not easily guessed and store it somewhere appropriate. If you forget the password, do not assume Calc can recover it; keep an authorized copy or password record so you can maintain the workbook.

To remove protection, select the protected sheet and choose Tools > Protect Sheet again. Enter the password if Calc asks for it. Once protection is off, users can edit cells according to their normal cell settings, and you can change which cells are protected. A password for sheet protection is not the same as a password that encrypts the file.

Also distinguish sheet protection from protecting the workbook’s structure. Sheet protection controls editing on an individual sheet. Workbook or document-level controls, where available, address different actions such as changing sheet structure. They do not replace a password that encrypts the file for opening.

What protection does not secure

Sheet protection is primarily an editing safeguard, not a confidentiality or cybersecurity feature. It helps prevent routine edits to locked cells, but it should not be treated as strong encryption, access control, or a reliable way to keep information secret. A recipient may still be able to view visible data, make a copy, or use other tools to work with the file. Do not put confidential information in a sheet merely because it is protected.

Protection also does not guarantee that every workflow will behave exactly as it does on an unprotected sheet. Editing a locked cell is blocked, and some structural or data operations may be restricted. If users need to sort a table, use filters, insert rows, or perform another task, try that task on a copy after protection is enabled. If it fails, reconsider the layout or the protection approach rather than assuming that a lock will preserve every feature unchanged.

For sensitive information, use appropriate file encryption and access controls, and share only the data each person is permitted to see. In Calc, file-opening protection is a separate option available when saving a document with a password. That is different from Tools > Protect Sheet and should be managed independently.

Hide formulas without confusing it with locking

Calc’s Cell Protection tab includes a Hide formula setting in versions that provide that option. It is intended to keep a formula from being displayed in the usual cell formula view while sheet protection is active. To use it, select the formula cells, open Format > Cells > Cell Protection, select Hide formula, and then protect the sheet.

Hiding a formula is not the same as locking a cell. A protected formula cell cannot ordinarily be edited while the sheet is protected; the Hide formula option concerns displaying the formula. Neither option makes the result or the underlying information a secret from a determined recipient. If formula confidentiality matters, share a version that does not contain the formulas or sensitive source data.

Common problems and fixes

Users can still edit a cell: Check that sheet protection is active and that the cell’s Protected setting is selected. A protected attribute alone has no effect until the sheet is protected.
Users cannot type in an input field: Remove protection, select the input cells, and clear Protected under Format > Cells > Cell Protection. Then enable protection again.
The menu asks for a password: The sheet is protected with a password. You need the correct password to remove protection through Calc’s normal interface.
A formula is visible: Confirm that Hide formula is selected for the formula cell and that sheet protection is active. Remember that hiding a formula is not encryption.
A pasted range behaves unexpectedly: Test pasting into the unlocked range on a copy of the workbook. Pasting can affect more than the value, and protected-sheet rules may block some changes.

When diagnosing a problem, use a duplicate file rather than experimenting on the only copy of an important workbook. Protection settings are easy to adjust when you have the password, but testing the intended user actions in advance is safer than discovering a restriction after distribution.

When to use another protection method

Use sheet protection when the goal is to reduce accidental edits while leaving selected cells available for data entry. It is a good fit for a reusable form, a classroom exercise, or a calculation sheet whose formulas should not be casually overwritten. It is not a substitute for restricting access to a file or hiding data from people who receive it.

If recipients must not open or read the document, use file encryption with a strong password and share that password through a separate appropriate channel. If several people need different permissions or a controlled editing history, a shared document service with account-based access and version history may be a better fit. For a public-facing form, consider collecting responses separately and keeping the calculation workbook private.

Before distributing any protected file, keep an editable master copy, confirm that you know the password, and test the recipient’s likely tasks. That small check helps ensure the sheet is protected enough to prevent mistakes without blocking legitimate work.

Frequently Asked Questions

How do I protect a sheet in LibreOffice Calc without a password?
Choose Tools > Protect Sheet and leave the password fields empty if the dialog allows it. Protection will still prevent ordinary edits to protected cells, but users may be able to turn protection off without a password.

Can I protect only certain cells in Calc?
Yes. Mark the cells that should remain editable as unprotected using Format > Cells > Cell Protection, then turn on protection for the sheet. The remaining protected cells are restricted while protection is active.

How do I unprotect a Calc sheet?
Choose Tools > Protect Sheet on the protected sheet and provide its password if requested. If you do not know a required password, Calc’s normal interface will not let you remove protection without it.

Does protecting a sheet prevent people from copying its data?
No. Sheet protection is designed to limit editing, not to guarantee that visible content cannot be copied, viewed, or extracted. Use file encryption and appropriate sharing controls for information that must remain private.

Can I protect formulas but leave cells for input?
Yes. Keep formula cells protected, clear the Protected setting for the input cells, and then protect the sheet. You can also select Hide formula for formula cells if you want to suppress their normal formula display, but that is not a security barrier.

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.