Lock a Column in Google Sheets: Freeze or Protect It

How-to basics · Updated November 20, 2026

To keep a column visible while you scroll in Google Sheets, freeze it with View > Freeze. To stop collaborators from changing its contents, protect the column with Data > Protect sheets and ranges. These are different actions, so choose the one that matches what you mean by “lock.” The steps below are for Google Sheets in a web browser; Excel uses different menus and settings.

What You’ll Need

  • A Google account with access to the spreadsheet. You need editing permission to change its freeze or protection settings.
  • The spreadsheet open in a desktop web browser. Some controls are harder to find on a phone or tablet, so use a computer for the steps below.
  • A clear idea of whether you want the column to remain visible, prevent edits, or both. Freezing and protecting can be used together.

Step-by-Step

  1. Open the spreadsheet and identify the column. Go to Google Sheets and open the file. Note the column letter, such as A for names or D for status. If the sheet has several tabs, choose the correct tab at the bottom before changing anything. Freeze and protection settings apply to the selected sheet, not automatically to every tab in the file.
  2. Choose what “lock” should do. If the column should stay on screen while you scroll sideways, freeze it. If other editors should not be able to change its cells, protect it. A frozen column is still editable; a protected column does not necessarily stay visible. Use both sets of steps if you need both results.
  3. Freeze the first column when it is column A. In the top menu, select View > Freeze > 1 column. Column A should remain in place as you scroll horizontally through the sheet. This is useful for keeping names, product IDs, or other row labels visible while you compare information farther to the right.
  4. Freeze multiple columns or a later column. To freeze columns A through C, select a cell in column C, then choose View > Freeze > Up to column C. The menu wording may show the current column letter. Google Sheets freezes the columns from the left edge through the selected column; it does not freeze only column C while leaving A and B scrolling. To freeze A and B, select a cell in B and choose the option up to column B, or choose 2 columns if that option appears.
  5. Check that the freeze worked. Scroll horizontally to the right using the bottom scrollbar. The frozen section should stay visible while the unfrozen columns move. A thicker gray divider marks the boundary between frozen and scrolling columns. If the sheet is narrow and you cannot scroll sideways, widen the browser window or use a sheet with more columns to confirm the behavior.
  6. Unfreeze columns if you chose the wrong amount. Select View > Freeze > No columns. This removes the frozen-column setting for the current sheet. You can then select the correct cell or number of columns and repeat the freeze step. Removing the freeze does not delete or alter any cell contents.
  7. Select the column you want to protect. Click its letter at the top of the grid to select the whole column. For a specific range instead, drag across the cells or enter a range such as A2:A100 in the range box. Protecting only the cells that need restrictions can leave the rest of the column editable for routine work.
  8. Open the protection panel. Choose Data > Protect sheets and ranges. In the panel that opens, select Add a sheet or range if needed. Give the rule a recognizable description, such as “Protect status column,” so you and other authorized editors can tell what it covers later. Confirm that the range shown is the intended one, for example A:A for all of column A.
  9. Set who can edit the range. Select Set permissions. To enforce a restriction, choose the option that restricts who can edit the range, then choose the allowed editors, such as only you or a custom list. Follow the on-screen prompts to save. If you select the warning option instead, Sheets warns people before they edit but still lets them proceed; that is not a strict lock.
  10. Test the result and communicate it. Try editing a protected cell, or ask an authorized collaborator to check it. The result depends on that person’s access and the permission you set. Let collaborators know which cells are protected and who can change them. If you also froze the column, scroll sideways to verify that it remains visible.

To protect just part of a column, open Data > Protect sheets and ranges and enter a specific range, such as D2:D50, rather than D:D. If you need to protect most of a sheet but leave a few input cells open, use the sheet-protection option and specify the cells that are exempt. Review the range displayed in the side panel before saving; a misplaced range can restrict the wrong cells.

Common Mistakes

  • Freezing when you meant to prevent edits. Freeze only changes what stays visible during scrolling. It does not stop someone from typing in a cell. Use range protection for editing restrictions.
  • Protecting when you meant to keep a label visible. Protection does not pin a column to the side of the screen. Use View > Freeze instead.
  • Thinking you can freeze a middle column by itself. Frozen columns always form a block starting at column A. To keep column D visible, for example, you must also freeze A through C.
  • Using a warning instead of a restriction. The warning setting is a reminder, not a barrier. Choose restricted editors if unauthorized edits must be blocked.
  • Applying protection to the wrong range or tab. Check the sheet tab and range in the protection panel. A whole-column range such as A:A includes new rows in that column; a range such as A2:A100 does not automatically cover cells below row 100.
  • Expecting a protected range to hide sensitive information. Protection controls editing; it is not a security or confidentiality feature. People with access to the spreadsheet may still be able to view or copy data.

Tips

  • Freeze a useful identifier column. Names, dates, item codes, or ticket numbers often make good frozen columns because they help you identify each row while comparing distant columns.
  • Keep the frozen area narrow. Freezing many columns can leave little room for the rest of the sheet, especially on a laptop. Freeze only the information you need to refer to while scrolling.
  • Protect only cells that need control. Leave input cells open when collaborators are expected to add data. A clear division between editable input fields and protected calculations or reference values can prevent accidental changes without blocking normal work.
  • Use a descriptive protection note. Names such as “Formula cells—owner only” are easier to understand than a generic label. This is particularly helpful when a file has several protected ranges.
  • Check the access list when the team changes. If someone no longer needs editing access, review the protection permissions as well as the spreadsheet’s general sharing settings. A protected range cannot grant access to someone who does not have access to the file at all.
  • Remember that freeze settings are not private to you. Frozen columns are part of the sheet’s layout and can affect how collaborators see it. Coordinate layout changes on shared workbooks so a freeze does not surprise other users.

Troubleshooting

The column does not stay visible. Confirm that you froze columns rather than rows: open View > Freeze and check the selected column option. For column A, use 1 column. For a later column, select a cell in that column first and choose the option that freezes up to it. Then scroll horizontally, not vertically, to check the result. If the wrong block is frozen, select No columns and set it again.

People can still change the cells. Reopen Data > Protect sheets and ranges and inspect the rule. Make sure it covers the correct range and that you chose restricted editing permissions rather than a warning. Check whether the person is on the allowed-editor list. Also confirm that they are editing the protected cells, not a nearby unprotected cell. Protection does not prevent the file owner from making changes, and users with sufficient permissions may be able to manage protection settings.

You cannot change the protection settings. Check whether you have editor access to the file. Viewers and commenters cannot set protections. If you can edit cells but cannot manage the rule, ask the owner or an administrator to update the permissions or make the change. The available controls can depend on your role and the organization’s Google Workspace settings.

The menu option is missing or disabled. Make sure the file is open in Google Sheets rather than a preview, and that you are signed into the account that has access. If the spreadsheet is an imported Excel file, convert it to Google Sheets if you need Sheets-specific controls: use File > Save as Google Sheets when that option is available. Google Sheets and Excel have different protection and freeze menus, so the steps may not match while editing an Excel-format file.

A collaborator says the protected column is not secure. Explain that range protection is designed to prevent accidental or unauthorized edits by spreadsheet collaborators, not to conceal information or replace file-sharing controls. Remove access to the spreadsheet for anyone who should not see its contents, and avoid storing confidential data in a shared file.

Frequently Asked Questions

Can I lock a column in Google Sheets so it stays visible?
Yes. Use View > Freeze > 1 column for column A. For a later column, freeze up to that column; Google Sheets also freezes the columns before it.

Can I lock a column so only I can edit it?
Yes, if you have the necessary access. Select the column, open Data > Protect sheets and ranges, choose Set permissions, and restrict editing to yourself or selected people. The file owner may retain the ability to edit.

Can I freeze and protect the same column?
Yes. Freeze it to keep it visible while scrolling, then add a protection rule to control who can edit it. These settings do different jobs and can be used together.

Can I freeze column C without freezing A and B?
No. Google Sheets freezes a continuous block from the left edge. Freezing up to column C keeps A, B, and C in place; it cannot keep C alone fixed.

Does protecting a column stop people from viewing or copying it?
No. Protection limits editing, not viewing or copying. Use the spreadsheet’s sharing settings to control who can open the file, and do not rely on range protection to hide sensitive information.

Does this work the same way in Excel?
No. Excel has its own Freeze Panes and Protect Sheet commands. The steps here use Google Sheets menus, so follow Excel-specific instructions when working in an Excel workbook.

Related

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.