Column Freezing for pivot tables
Tuesday, June 23, 2026
What it is
Pivot tables now default to keeping the left-side columns and the right-side Totals columns frozen while you scroll horizontally.
Why it matters
A pivot table with many columns made it hard to keep track of which value tied to which column once you scrolled. Freezing the labels and the totals keeps a wide table readable.
The Take
This is the kind of change nobody asks for by name and everybody benefits from. A wide pivot table without frozen columns forces you to scroll back to the left to remember what row you are reading, which is how misread numbers make it into a deck.
Worth noting it is a default, not a setting you have to find. If you build wide reports, your existing pivot tables get more readable without you doing anything.
Produced by Value-First Media