Freeze Panes in Google Sheets for Excel Users

How Freezing Differs Between Excel and Google Sheets

Freezing is how you keep a model readable once it grows past one screen: the period headers stay at the top while you scroll down through line items, and the labels stay on the left while you scroll across years. Both tools do it, but they think about it differently.

Excel freezes from a cell. You click the first cell that should scroll, and Freeze Panes locks everything above it and everything to its left in one action. On the keyboard that is Alt + W + F + F, with Alt + W + F + R for the top row only and Alt + W + F + C for the first column only.

Google Sheets freezes by count. You tell it how many rows to freeze and, separately, how many columns. There is no single command that reads the selected cell and sets both.

Task	Excel	Google Sheets (Native)	Google Sheets With ShortieCuts
Freeze rows and columns at a cell	Alt + W + F + F	View > Freeze > Up to row, then View > Freeze > Up to column	Alt + W + F + F
Freeze top row	Alt + W + F + R	View > Freeze > 1 row	Alt + W + F + R
Freeze first column	Alt + W + F + C	View > Freeze > 1 column	Alt + W + F + C
Unfreeze	Alt + W + F + F (Unfreeze Panes)	View > Freeze > No rows, then No columns	Alt + W + F + F again when both are frozen

Freezing Natively in Google Sheets

If you are on a machine without ShortieCuts, the native route is the View menu:

1. Click a cell in the last row you want frozen.
2. Open View > Freeze. The menu offers No rows, 1 row, 2 rows and Up to row n, where n is the row of the selected cell.
3. Choose the row option you want.
4. Click a cell in the last column you want frozen, open View > Freeze again and choose the column option: No columns, 1 column, 2 columns or Up to column x.

Note the difference in what you click. Excel wants the first cell that scrolls; the Sheets Up to row option wants a cell in the last row that stays put. Excel users often freeze one row too few in Sheets because of this.

The other native method is dragging. At the top-left corner of the grid, above row 1 and left of column A, there are thick gray bars. Drag the horizontal one down to freeze rows and the vertical one right to freeze columns.

One-Stroke Freeze With ShortieCuts

ShortieCuts restores Excel's behavior on Excel's keys.

1. Click the first cell that should scroll. In a typical model with a title block in rows 1 to 4 and labels in columns A and B, that is C5.
2. Press Alt (Option on a Mac). Excel-style key-tips appear.
3. Type W, F, F.

Rows 1 to 4 and columns A and B are now frozen in one action, exactly as Freeze Panes would do in Excel. Press Alt + W + F + F again while both rows and columns are frozen and they unfreeze, which is the same toggle you know from Excel's Unfreeze Panes.

For the narrower cases:

• Alt + W + F + R freezes the top row, the usual choice for a data export with a single header row.
• Alt + W + F + C freezes the first column, useful for a wide time series with labels in column A.

Things That Behave Differently in Sheets

Freezing Always Starts at Row 1 and Column A

In Excel, if you have scrolled down before freezing, the rows scrolled out of view stay hidden above the frozen area. Sheets counts from the top of the sheet, so the frozen block always begins at row 1 and column A. If your headers sit in rows 6 and 7 below a tall title block, freezing at row 8 locks all seven rows. The fix is a compact title block: keep the model name, units and scenario switch in two or three rows rather than eight.

The Frozen Area Is Shared

In Sheets, frozen rows and columns are a property of the tab, saved with the file. Everyone who opens it sees the same frozen area, and if a colleague changes it, it changes for you too. On a shared model, agree on a freeze line and leave it.

Merged Cells Can Block a Freeze

Sheets will not freeze through a merged cell that straddles the freeze line, for example a title merged across columns A to F when you try to freeze at column C. Unmerge the title with Alt + H + M + U, or keep merges entirely inside or outside the frozen block. Problems like this are one reason many modelers avoid merged headers in working tabs.

There Is No Split View

Excel's Split, which divides the window into independently scrolling panes, has no equivalent in Sheets. If you relied on Split to compare two distant parts of one tab, the nearest workaround is to open the same file twice. With ShortieCuts, Alt + W + N opens the spreadsheet in a new browser tab, which you can drag into its own window beside the first. For background on how Split works in Excel, see splitting a worksheet into panes.

Tips for Laying Out a Frozen Model

• Freeze the period header row, not the whole title block. The years or months are what you need to see while scrolling.
• Keep the frozen area small on a laptop. A frozen block that takes half the screen leaves little room to scroll.
• Freeze each tab separately. Freezing is per tab in both Sheets and Excel, so set it on the inputs, model and output tabs individually.
• Pair it with the other View keys. Alt + W + V + G toggles gridlines for a cleaner printout look, Alt + W + Q sets zoom, and Alt + W + J returns to 100%.

All the View-tab sequences, and the rest of the 230+ Excel shortcuts ShortieCuts supports, are on the shortcuts index. For the broader picture of what else changes when you move from Excel, see Google Sheets vs. Excel. ShortieCuts runs in Chrome; plans and the 14-day free trial are on the pricing page.

FAQ