If you need to lock formula in Google Sheets, the key idea is simple: you protect the cells that contain the formula so other people can’t edit or overwrite them. That is not the same as hiding the formula or freezing a row, and it is not the same as locking a view. Once you know the difference, you can control who can edit a single formula, a whole range, an entire sheet, or just a column.
Lock a formula in Google Sheets the right way
Google Sheets does not have a special “lock formula” button. Instead, you lock the cell or range that contains the formula by protecting it. If a cell is protected, anyone without edit permission for that range cannot change the formula inside it.
Protect the formula cell or range
- Open your sheet and click the cell that contains the formula.
- Drag to select the full range if the same formula is copied across multiple cells.
- Right-click the selection and choose View more cell actions, then Protect range.
- In the side panel, enter a description if needed, then click Set permissions.
- Choose Restrict who can edit this range.
- Select who can still edit it, or choose only yourself.
- Click Done.
This is the cleanest way to lock formulas in Google Sheets when you want the calculation to stay intact but still want the rest of the sheet editable.
Lock a formula cell with a reference that does not move
If your real problem is that a formula changes when you copy it, use absolute references inside the formula. For example, $A$1 stays fixed when you fill the formula across rows or columns. That does not protect the cell from edits, but it does lock the reference in the formula itself, which is what many people mean when they search for how to lock a formula in Google Sheets.
Lock cells in Google Sheets so others cannot edit them
To lock cells in Google Sheets, protect the range. This works for one cell, a block of cells, a full column, or a whole sheet. The protection controls editing, not viewing, so people can still see the data unless you hide it some other way.
How to lock a Google Sheets cell
- Select the single cell.
- Open Protect range.
- Click Set permissions.
- Allow only specific editors, or allow only you.
- Save the rule.
This is the exact answer to how do I lock cells in Google Sheets when you only need one input cell, one formula cell, or one sensitive value protected.
How to lock a value in Google Sheets
Locking a value follows the same process as locking a formula. If the value is manually entered and should never be changed by collaborators, protect that cell or range. If the value should remain visible but not editable, range protection is the correct tool. If the value should not be seen, use data separation or another permission structure, because protection alone does not hide content.
Lock columns, rows, and whole sheets
When you want to stop edits across a larger area, protect the column, row, or entire worksheet. This is useful for template files, shared trackers, and sheets where only one input area should stay open.
How to lock a column in Google Sheets
- Click the column letter at the top to select the entire column.
- Right-click and choose Protect range.
- Set the range name if needed.
- Choose who can edit it.
- Save the protection.
Use the same method for how to lock columns in Google Sheets when you want every cell in that column to stay unchanged, including formulas, headers, and notes.
How to lock entire sheet in Google Sheets
- Open the sheet tab you want to protect.
- Right-click the tab name and choose Protect sheet.
- In the side panel, choose Set permissions.
- Decide whether to allow only certain people, or only you, to edit the sheet.
- Save the rule.
This answers how to lock sheet in Google Sheets and how to lock worksheet in Google Sheets. It is the best option when the whole tab should stay fixed except for a few controlled areas.
Keep one section editable while the rest stays locked
If you need collaborators to enter data in a few cells but not touch formulas, protect the whole sheet first, then open specific ranges for editing. This is the safest structure for shared trackers, calculators, and dashboards.
Allow edits in only a few cells
- Protect the entire sheet.
- Open the protection settings.
- Choose Except certain cells or add allowed ranges.
- Select the cells that users can edit.
- Save the configuration.
With this setup, the formulas remain locked, while input cells stay available. That is the best answer to how to lock formulas in Google Sheets without making the whole file unusable for teammates.
Lock a formula in a row or table
If a formula is copied down a table, protect the whole calculated column after the formulas are in place. Do not protect only the first cell if users can still paste over the rest of the column. Locking the full formula column prevents accidental overwrites and keeps the calculation consistent from top to bottom.
Password protection, Excel files, and sheet views
People search for how to lock Google Sheets with password, but Google Sheets does not use a password to protect a range inside the file. Access is controlled through sharing permissions and range protection. If someone can open the file, they can see protected cells unless the file is separately restricted at the Drive level.
How to lock Google Sheets with password
There is no built-in password lock for a single Google Sheet or a sheet tab. Use Google account sharing permissions instead. If you need a stronger restriction, share the file only with specific people and remove link access. For cells and sheets inside the file, use protection rules to limit editing.
How to lock cells in Excel Google Sheets
If you imported an Excel workbook into Google Sheets, the Excel lock settings do not carry over as a final protection system. Recreate them with Google Sheets protections. Select the cells, ranges, or sheet tabs you want locked, then set permissions inside Google Sheets. That is the correct way to lock Excel in Google Sheets after import.
How to lock filter view in Google Sheets
A filter view is not locked the same way a cell is locked. If you want to preserve a filter view, create it under Data and keep the sheet protected so editors do not change the underlying data or remove the filter setup. If the issue is that people should not edit the view, control their edit access to the sheet rather than looking for a separate view lock.
How to lock down a view in Google Sheets
Google Sheets does not offer a private view lock for a normal sheet view. What you can lock is the underlying data, the formula cells, and the sheet structure. For a stable shared display, protect the sheet and limit who can edit it. For a reusable visual setup, use a protected tab and assign edit access only where necessary.
Frequently Asked Questions
Can you lock formulas in Google Sheets?
Yes. Protect the cells or ranges that contain the formulas. That blocks edits to the formulas while leaving the rest of the sheet available if you do not protect it.
How do I lock a cell in Google Sheets formula?
Use protection for the cell, and use absolute references inside the formula if you want the reference itself to stay fixed. Protection stops edits. Dollar signs in a formula stop references from shifting.
How to lock formulas in Google Sheets without locking the whole sheet?
Protect only the formula cells or the formula column. Leave input cells unprotected. That gives you a shared sheet where formulas stay intact and users can still type into designated areas.
How to lock a column in Google Sheets without affecting other columns?
Select the full column, protect that range, and allow only approved editors. Other columns remain editable unless you protect them too.
How to lock Google Sheets with password?
You cannot password-protect a range or sheet tab inside Google Sheets itself. Use file sharing permissions and protected ranges instead.
How to lock an entire sheet in Google Sheets?
Right-click the sheet tab, choose Protect sheet, then set who can edit it. This locks the worksheet structure and content except for any ranges you intentionally leave open.
Related Posts:
Google Sheets
- How to Freeze Rows and Columns in Google Sheets
- How to Merge Cells in Google Sheets
- How to Calculate Totals in Google Sheets
- How to Insert Multiple Rows in Google Sheets
- How to Change Cell Width in Google Sheets
- How to Add Cells and Columns in Google Sheets (SUM)
- How to View Hidden Sheets and Rows in Google Sheets
- How to Remove a Drop-Down in Google Sheets
- How to Convert Google Sheets to Excel
- How to Sort in Google Sheets (A to Z, by Column)
- How to Delete or Remove a Filter View in Google Sheets
- How to Make a Graph in Google Sheets
- How to Remove Duplicates in Google Sheets
- How to Calculate Days Between Dates in Google Sheets
- How to Change Cell Color With a Formula in Google Sheets