How to Freeze a Column in Google Sheets

Name: How to Freeze Rows & Columns in Google Sheets
Uploaded: 2026-03-03
Duration: 2 min 59 s
Description: Learn how to freeze a column in Google Sheets with menu steps, shortcuts, and practical tips. This guide covers single and multiple columns to keep headers and IDs visible while you scroll.

Learn how to freeze a column in Google Sheets with menu steps, shortcuts, and practical tips. This guide covers single and multiple columns to keep headers and IDs visible while you scroll.

How To Sheets Team

March 3, 2026·5 min read

Google-Sheets-Free Open-In-Google-Sheets

Freeze Columns in Sheets - How To Sheets — Photo by www.kaboompics.com via Pexels

Quick AnswerSteps

Learn how to freeze a column in Google Sheets so important data stays visible as you scroll. This guide covers menu-based freezing, keyboard shortcuts, and tips for freezing multiple columns and headers. You'll see practical examples and quick checks to ensure the panes stay locked across sheets. You will also learn when to apply frozen panes for dashboards and collaboration, plus how to remove or adjust freezes without losing your layout.

Why freezing columns matters

Freezing columns is a simple but powerful technique that keeps key identifiers visible as you scroll through large data sets in Google Sheets. When you work with wide spreadsheets, headers, IDs, or category labels become hard to track. If you wonder how to freeze column in google sheets, freezing the leftmost columns or header rows ensures your important context stays in view. This makes comparisons, data validation, and collaborative reviews more efficient and less error-prone. According to How To Sheets, freezing panes is a foundational skill for managing wide spreadsheets. This practice is especially valuable for dashboards, budgets, or lists where column order conveys meaning. In this section, you’ll learn the core reasons to freeze panes and how this affects navigation, readability, and accuracy across devices and screen sizes.

When to freeze columns vs rows

Freezing columns is most helpful when the leftmost data (like ID numbers, names, or categories) is essential for understanding every row you review. If your sheet is wide with many columns, freezing a column or two keeps the identifying fields visible while you scroll horizontally to the right. Freezing rows, by contrast, keeps headers visible as you move downward. In practice, teams often freeze headers and the first column for dashboards and reports. Consider your workflow: do readers need persistent identifiers, or do column headers matter more as you skim the dataset? The decision should align with how you review, sort, and compare rows in day-to-day tasks.

When you freeze a column, the frozen area remains stationary while the rest of the sheet scrolls. This creates a stable reference point for comparing values, trends, or categories across many rows. Shadows and subtle UI cues indicate which pane is locked. On larger screens, frozen panes reduce eye strain and help prevent misreads during data entry or auditing. On smaller devices, the effect is similar, though the visible area shrinks; you may need to adjust how many columns you freeze to maintain clarity. Overall, freezing improves accuracy and speed by keeping crucial anchors in view.

In Google Sheets, most users access freezing through the View menu. The typical options are Freeze > Up to current column (or row) and Freeze > 1 column (or 1 row). The exact wording may vary slightly by interface or updates, but the concept remains the same: you choose which edge to lock by selecting the cell to the right of the last column you want frozen (or below the row you want frozen). This centralized approach makes it easy to apply freezes consistently across multiple sheets in a workbook.

Freezing multiple columns and headers: how to extend the lock

To freeze more than one column, place the active cell in the column immediately to the right of the last column you want frozen, then choose Freeze > Up to current column. For example, to lock columns A through C, select column D and apply the command. You can simultaneously freeze the top header row by selecting a row beneath it (e.g., row 2) and choosing Freeze > Up to current row. Freezing both axes is often used for complex dashboards where the leftmost data and top headers must stay visible during analysis.

Practical examples across common use cases

Imagine a sales dashboard where Column A holds the region and Column B the salesperson. Freezing the first two columns ensures you can scroll through hundreds of rows without losing sight of who is responsible for each row. For a student roster, freezing the Name and ID columns helps tutors track students as you scroll through assignments or grades. In inventory lists, freezing the Item ID column lets you compare stock levels against dates or locations without losing context. These scenarios illustrate how frozen panes improve readability and reduce review time.

Removing or adjusting freezes: quick cleanup

If you later need to adjust or remove freezes, return to View > Freeze and choose No columns or No rows (depending on what you froze). This resets the pane locks, so you can reapply a new set of freezes tailored to changing data structures. When removing freezes, verify that the sheet still maintains its alignment across all devices and that collaborators see the same layout. If the sheet is part of a shared workbook, communicate the change to avoid confusion or misinterpretation.

Best practices for consistency and collaboration

Adopt a standard for which panes to freeze in your team’s Google Sheets templates. Document the choice in a header note or a template guide, so new collaborators apply the same settings. Regularly verify that frozen panes remain correct after sorting, filtering, or importing data. For dashboards distributed across devices, test freezes on desktop and mobile to ensure the anchor columns stay visible. Finally, pair freezing with clear column ordering and consistent header naming to maximize clarity and reduce mistakes.

Tools & Materials

Computer or tablet with Google Sheets access(Stable internet connection; ensure you are signed in to the correct Google account)
Target Google Sheet(Identify the column(s) or header row you want to freeze before starting)
Optional: external display(Larger screen can help visualize freezes for teaching or demonstrations)

Steps

Estimated time: 4-6 minutes

1
Open the sheet and identify the anchor edge
Open the Google Sheets document and decide which column (and optionally which row) should anchor the view. This will be the edge you freeze. Selecting the right anchor minimizes the amount of scrolling needed while preserving context.
Tip: If you’re freezing a header, the anchor edge is the column immediately to the right of the header.
2
Place the active cell to the right of the edge to freeze
Click in the column immediately to the right of the last column you want frozen (or in the row below the last header you want frozen). This step determines how many columns or rows will lock.
Tip: For freezing the first column, place the active cell in column B.
3
Open the Freeze menu
Go to the menu bar and select View > Freeze. This reveals options to freeze columns or rows up to the current position.
Tip: If you don’t see options, ensure you are in a Google Sheets document in a supported browser.
4
Choose the appropriate freeze option
Choose "Up to current column" to freeze all columns from the left edge up to the selected edge, or choose a specific option like 1 column when available.
Tip: Review the locked area by scrolling slightly to confirm the correct columns are anchored.
5
Freeze the header row if needed
If your sheet has a header row, repeat the same process for rows by moving the active cell to the row below the header and selecting the corresponding Freeze option.
Tip: Freezing headers improves readability when scanning long lists.
6
Verify the result
Scroll horizontally and vertically to ensure the intended columns and rows stay in view. Confirm that the frozen area remains stationary while the rest of the data moves.
Tip: If the pane isn’t locked correctly, undo and retry with the correct edge.
7
Lock multiple axes if required
To freeze both left columns and the header, freeze the left edge first and then freeze the top row. Do not mix orders to avoid confusing behaviors.
Tip: Document the combined settings in your sheet’s legend for teammates.
8
Remove or adjust freezes later
If you need to resize the frozen area, return to the Freeze menu and select a different edge or choose No columns/No rows to clear the freeze, then reapply as needed.
Tip: Always re-check the view after adjusting to maintain consistency.

Pro Tip: Create a shared template with predefined freezes to ensure consistency across teams.

Warning: Avoid freezing too many columns; over-freezing can hinder editing and increase confusion on small screens.

Note: On mobile apps, freezes may behave slightly differently; verify on both devices if your audience uses mobile.

FAQ

Can I freeze more than one column at once?

Yes. To freeze multiple columns, place the active cell in the column immediately to the right of the last column you want frozen, then choose "Up to current column" from the Freeze menu. Validate by scrolling to confirm the lock.

How do I freeze the first row and the first column at the same time?

First freeze the first row by selecting the row below the header and choosing the 1 row option. Then freeze the first column by selecting column B and choosing Up to current column. This locks both axes for easier data review.

How do I remove a freeze?

Go to View > Freeze and select No columns or No rows to clear the existing freeze. Reapply the desired edges if needed.

Do freezes apply the same on mobile devices?

Generally yes; the frozen panes stay visible when viewing on mobile, but UI differences can affect how you access the Freeze menu. Verify on the app for your device.

Is there a keyboard shortcut for freezing panes?

There is no universal built-in shortcut in Google Sheets. Use the View menu to freeze, or consider recording a macro for a repeatable action.

Will freezing affect charts or ranges in the sheet?

Freezing only affects the viewport; charts and data ranges update normally based on the visible data. Ensure the data range includes the frozen columns if needed for accurate charts.