You’re scrolling right through a wide sheet and the label column on the left disappears. Now you’re staring at numbers with no context for which row is which.
Freezing the left column (or first few columns) pins them so they stay on screen no matter how far right you scroll. It’s one of the most useful layout tools in Sheets for wide datasets.
Google Sheets doesn’t have a built-in keyboard shortcut for freezing columns on Windows or Mac. The fastest route is the View menu freeze options.
Is There a Keyboard Shortcut for Freezing Columns in Google Sheets?
Freeze Column Keyboard Shortcut (
Windows)
No native keyboard shortcut on Windows. Use the View menu below.
Freeze Column Keyboard Shortcut (
Mac)
No native keyboard shortcut on Mac. Use the View menu below.
There’s no key combo for this on either platform. Google just hasn’t added one. The View menu is the next-fastest thing and only takes two clicks, so it’s not much of a loss.
When you freeze columns, Sheets pins them to the left edge. Scroll as far right as you like and those columns stay put while the rest of the data slides under them. A faint gray line marks where the frozen area ends and the scrollable area begins.
How to Freeze a Column in Google Sheets (Step by Step)
- Open the sheet you want to work with.
- Click View in the menu bar.
- Hover over Freeze. A submenu opens.
- Pick the option that fits:
– No columns removes any existing freeze. – 1 column pins column A. – 2 columns pins columns A and B. – Up to current column pins everything from A up to the column your cursor is in.
- Scroll right. The frozen columns stay locked on screen.
Quick example. You have a sheet with employee names in column A and 20 columns of monthly performance data stretching to column U.
Click any cell in column A, then go View → Freeze → 1 column. Now scroll to October’s numbers in column N. The name column stays anchored on the left so you always know whose row you’re reading.
To freeze A and B together, repeat the steps and pick 2 columns instead.
Another Way to Freeze a Column
There’s a draggable handle hidden in plain sight:
- Look at the top-left corner of the sheet, where the column letters meet the row numbers.
- You’ll see a thick gray bar sitting at the edge of column A. It’s the same width as a column border but darker.
- Click it and drag it to the right. Drop it after whichever column you want as the freeze line.
Drag the same bar all the way back to its starting position to remove the freeze. The bar gives you finer control than the menu when you want a freeze line that doesn’t match a preset.
Things to Watch For
- Combine with frozen rows. Freezing the top row and the first column at the same time creates a fixed corner that stays visible while you scroll in both directions. Great for label-heavy datasets.
- Screen real estate. Freezing four or five columns eats a lot of the visible area on a laptop or smaller screen. Two is usually the sweet spot.
- Mobile is similar but menu-driven. On the Sheets mobile app, tap the column letter and pick Freeze from the popup.
- Printing. Frozen columns don’t behave as repeating titles on a printout. For that, use File → Print → Headers & footers → Repeat frozen columns.
- The freeze travels with the file. Anyone else opening the sheet sees the same freeze you set up. It’s a sheet-level setting, not a per-user view.
Google Sheets keyboard shortcuts
Related Google Sheets shortcuts: