Freeze Panes in Google Sheets for Excel Users
In ShortieCuts, Alt + W + F + F freezes rows and columns together from the selected cell in Google Sheets, just as in Excel. Without it, Google Sheets makes you set rows and columns separately from the View menu.
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:
- Click a cell in the last row you want frozen.
- 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.
- Choose the row option you want.
- 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.
- 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. - Press Alt (Option on a Mac). Excel-style key-tips appear.
- 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 233 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
How do I freeze panes in Google Sheets?
Natively, open View, then Freeze, and choose a number of rows, then repeat for columns. You can also drag the thick gray bars at the top-left corner of the grid. With ShortieCuts, select the cell below and to the right of what you want locked and press Alt + W + F + F.
How do I unfreeze panes in Google Sheets?
Natively, choose View, Freeze, No rows, then View, Freeze, No columns. With ShortieCuts, pressing Alt + W + F + F again when both rows and columns are frozen unfreezes them.
Can I freeze just the top row or first column?
Yes. Natively use View, Freeze, 1 row or 1 column. With ShortieCuts, Alt + W + F + R freezes the top row and Alt + W + F + C freezes the first column.
Do other people see my frozen rows?
Yes. In Google Sheets frozen rows and columns are saved with the tab, so everyone who opens the file sees the same frozen area.
More Guides
- Trace Precedents and Dependents in Google SheetsCtrl + [ and Ctrl + ], step by step, plus native workarounds.
- Alt + H + O + I in Google SheetsAutoFit column width the Excel way.
- Excel Shortcuts That Don't Work in Google Sheets (and How To Get Them Back)ShortieCuts brings back the Excel keys that stop working in Google Sheets: the Alt ribbon Key Tips, F4 repeat, Ctrl + [ tracing, Ctrl + 9 and Ctrl + 0, one-stroke freeze panes and Goal Seek. The basic copy, paste and formatting keys carry over on their own.
- Goal Seek in Google Sheets for Excel UsersIn ShortieCuts, Alt + A + W + G opens Goal Seek in Google Sheets with the same three boxes as Excel, so you can backsolve a model the way you would in Excel. Google Sheets has no Goal Seek command of its own.
- Paste Special in Google Sheets for Excel UsersIn ShortieCuts, Alt + E + S + V pastes values in Google Sheets, along with the rest of Excel's Alt + H + V and Alt + E + S sequences. Google Sheets itself has a Paste special menu and two native shortcuts; here is the full key map, the one shortcut that means something different, and what Sheets cannot do at all.
- F4 and Absolute References in Google SheetsIn ShortieCuts, F4 repeats the last ShortieCuts command in Google Sheets when you are not editing a cell, just as in Excel. While you edit a formula, Google Sheets already cycles a reference through its dollar-sign forms with F4, so that part needs no extension.