Freeze rows & columns · Zoom

View ▸ Freeze pins the first N rows and/or columns so they stay under the headers while the rest of the grid scrolls, with a divider marking the split; View ▸ Zoom scales the whole grid surface — cell pitch, cell text, the header strips and any user-resized row/column — to one of seven presets.

What it does

View ▸ Freeze pins the top rows and/or the leftmost columns of the sheet so they stay put while the rest scrolls — the way you keep a header row visible over a long table. The submenu offers the same eight choices Sheets does:

No rows · 1 row · 2 rows · Up to row N
No columns · 1 column · 2 columns · Up to column X

N and X follow the active cell, so "Up to row 5" is how you freeze more than two. Frozen rows and frozen columns are independent; apply both and the top-left block stays fixed on both axes. A grey divider marks each split, drawn across the header strip as well as the cells. A freeze is part of the document — it is saved with the workbook and comes back on reload.

View ▸ Zoom scales the grid to 50%, 75%, 90%, 100%, 125%, 150% or 200%. It scales the grid surface only — cell sizes, cell text, the row-number gutter, the column-header strip, and any row or column you resized yourself, all by the same factor. The menu bar, toolbar and formula bar are untouched: this is not a browser zoom, and it changes nothing about the document. The current level carries a check in the menu. Unlike a freeze, zoom is per session: reload and you are back at 100%, matching the reference behavior recorded in the oracle brief.

Try it

Open View ▸ Freeze ▸ 1 row and scroll — row 1 stays put. Then try View ▸ Zoom ▸ 150% and watch the headers scale with the cells.

Verified behavior

Matches Google Sheets: Observed live in the reference workbook (this feature's oracle brief, studied 2026-08-05). View ▸ Freeze is a one-level submenu of exactly eight rows in two separator-divided groups — "No rows / 1 row / 2 rows / Up to row N" and "No columns / 1 column / 2 columns / Up to column X" — where N and X track the ACTIVE CELL and update live as the selection moves. The submenu shows no current-state marker at all: with two rows and two columns already frozen, none of the eight rows carries a check, a radio dot or aria-checked. Frozen rows do not scroll: with 2 rows frozen and the body paged down to row 70, rows 1 and 2 stayed pinned directly under the column headers, keeping their real row-header numbers; frozen columns behave identically on the other axis, and with both applied the top-left block stays fixed under scrolling on both axes. The split is drawn as a solid #C7C7C7 band 4 CSS px thick that crosses the header strips as well as the cell area — the horizontal one spans the full grid width including the row-number gutter, the vertical one the full height including the column-header strip — with the sheet's ordinary 1px #E1E1E1 gridline still rendered immediately before it. A freeze SURVIVES a page reload: it is document state. View ▸ Zoom is a second one-level submenu of exactly seven fixed presets — 50%, 75%, 90%, 100%, 125%, 150%, 200%, with no "Custom…" row anywhere (the toolbar's own zoom dropdown lists the identical seven) — and unlike Freeze it DOES mark the current level with a ✓. Zoom scales the grid surface and only the grid surface, proportionally: measured at 75% against 100%, the row-number gutter went 45.5 → 34 CSS px, a user-resized column 26 → 19.5, the row pitch ≈21 → ≈16, and the header glyphs shrank with them, while the menu bar, toolbar, formula-bar row and sheet-tab strip were pixel-identical. Zoom applies to the frozen panes too, and the freeze divider's thickness scales with it (4 → 3 CSS px at 75%) though its colour does not. Zoom does NOT survive a page reload — a workbook left at 75% came back at 100% in the very same reload that restored the freeze intact. It changes no cell value, formula or format. A second pass measured three more things the first one had left unobserved: "Up to row N" freezes INCLUSIVELY (active cell on row 3, "Up to row 3" clicked, divider landed below row 3 with row 4 the first scrolling row); freeze is PER SHEET (Sheet1 frozen 3 deep, Sheet2 showed no divider at all); and zoom above 100% scales by exactly the same single factor as below it (at 150%: gutter 90 → 135 device px, row pitch 42 → 63, a resized column 54 → 81, divider 8 → 12 — ×1.5 in every case).