Skip to content
Back to template gallery
Google Sheets
Google Sheets

How to freeze a column in Google Sheets

Keep the first column on screen while you scroll across a wide sheet.

Operations
5 steps 2 min Community template
1

Click a cell in the column

Click any cell in the column you want to keep in view - here, column A.

docs.google.com/spreadsheets/
Click a cell in the column
2

Click View

Open the View menu.

docs.google.com/spreadsheets/
Click View
3

Click Freeze

Hover over Freeze.

docs.google.com/spreadsheets/
Click Freeze
4

Click 1 column

Choose 1 column. Pick Up to column ... to freeze every column up to the selected one.

docs.google.com/spreadsheets/
Click 1 column
5

Column frozen

A thick line now marks the edge of column A. It stays in place as you scroll right. Choose View > Freeze > No columns to undo it.

docs.google.com/spreadsheets/
Column frozen

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.