What This Update Actually Is
HubSpot pivot tables can get wide. When you add multiple dimensions and a full date range, you can easily end up with dozens of columns stretching far to the right.
Before this update, scrolling horizontally meant your row labels scrolled off the left edge. Your Totals column disappeared off the right. You'd end up squinting at a number with no idea which row or column it belonged to.
Now both anchor points stay locked. The left-hand label columns freeze in place. The Totals columns on the right freeze in place. Scroll as far as you want. The context never disappears.
This is a default-on behavior. There's nothing to enable, no toggle to flip. Every existing pivot table in your portal got this upgrade automatically.
Why HubSpot Shipped This
The external problem is readability. Pivot tables are built for dense, multi-dimensional data. The more valuable the report, the more columns it tends to have.
The internal frustration is subtler. When humans can't read a report confidently, they stop trusting it. They pull the data into a spreadsheet instead. They ask a RevOps team member to recreate it. The report exists but it doesn't get used.
We've seen this pattern in portal audits across industries. A beautifully built pivot table sits on a dashboard and gets ignored because the person reviewing it can't scroll through it without losing their mental model of the data.
HubSpot's fix is the right call. Frozen columns are the industry standard in spreadsheet tools for exactly this reason. Bringing that behavior into native HubSpot reporting removes a real barrier to data adoption.
How to Use It Step by Step
There's no activation required. But here's how to get the most out of this change starting today.
- Open any existing pivot table report in your HubSpot portal.
- Scroll horizontally through the table. Confirm that the left-hand label columns and the right-hand Totals columns remain visible and locked.
- Audit any pivot tables your team previously avoided or exported to spreadsheets because of scroll confusion. Those reports are now usable natively.
- If you build new pivot tables with many date-based or dimension-based columns, add them to dashboards with confidence. The frozen anchors will hold regardless of how wide the table grows.
- Share the updated reports with stakeholders who previously needed exported spreadsheets. Walk them through the frozen-column behavior so they know the native tool can handle the volume.
What It Touches in Your HubSpot Strategy
This update is narrowly scoped to the pivot table view inside HubSpot's report builder. But the ripple effects on how humans actually use reporting are broader than they look.
Pivot tables pull from every object in the CRM. Contacts, companies, deals, tickets, custom objects. If you're doing cross-object analysis, your pivot tables are likely your widest reports. Those are the exact reports that suffered most from the old behavior.
Key Takeaway
Any pivot table report that lives on a shared dashboard now communicates more clearly to every stakeholder who opens it, without any extra effort from the person who built it.
For RevOps teams managing reporting across Sales Hub, Marketing Hub, and Service Hub data simultaneously, this is a quiet win. Blended performance reports, pipeline-by-stage-by-owner tables, and multi-channel attribution breakdowns are all more usable today than they were yesterday.
There's also a data trust angle. When reports are hard to read, teams work around them. They export to Excel. They build shadow spreadsheets. Data gets stale. Decisions get made off unofficial versions of the truth. Removing scroll confusion from pivot tables is one less reason to leave HubSpot to get the answer.
Key Takeaway
If your team has been exporting pivot table data to spreadsheets just to make it readable, this update is your cue to rebuild those workflows inside HubSpot natively.
Who Should Care Most
This update is small in scope but specific in value. Here's who gets the most out of it.
- RevOps managers who build and maintain cross-object pivot tables for leadership reviews and QBRs
- Marketing ops leads running multi-channel attribution reports that span many date columns or campaign dimensions
- Sales managers tracking pipeline performance by rep, stage, and time period in a single pivot view
- Service team leads reviewing ticket volume by category, priority, and time window
- Business owners who review shared dashboards but don't build reports themselves, specifically those who've complained that HubSpot reports are hard to follow
Every hub and every tier gets this. Free portals, Starter portals, Professional and Enterprise alike. There's no upgrade required to benefit.
George's Take
I'll be honest: this one isn't flashy. It's not AI. It's not a new object or a new automation pattern. But I've been in enough portal audits to know exactly what this update fixes. There's always a pivot table someone built with real care, living on a dashboard, and getting zero engagement because the humans reviewing it couldn't scroll through it without losing the plot. That's not a data problem. That's a readability problem. And readability problems quietly destroy trust in your reporting system. Frozen columns are a small fix with a disproportionate impact on whether your data actually drives decisions.
“A pivot table no one can read is just noise with a nice header. Frozen columns turn that noise back into signal.”
If you want to build a reporting system in HubSpot that your whole team actually uses, and not just one that technically exists, we'd love to dig into your portal with you.
Book a strategy call with the Sidekick team. We'll review your current dashboards and pivot tables, identify what's being ignored and why, and help you build a reporting foundation that humans trust and actually return to.
Frequently Asked Questions
What does HubSpot's pivot table column freezing update actually do?
HubSpot now locks two sets of columns by default in every pivot table: the label columns on the left side and the Totals columns on the right side. When you scroll horizontally through a wide pivot table, both anchor columns stay visible. No setting change is required. This behavior is on for all portals automatically.
Do I need to change any settings to enable frozen columns in HubSpot pivot tables?
No. Frozen columns are enabled by default for all pivot tables in HubSpot as of June 23, 2026. Every existing pivot table in your portal already has this behavior. There's nothing to configure, enable, or toggle. It works the same way across every hub and every tier.
Which HubSpot hubs and tiers does the pivot table column freezing update apply to?
This update applies to all HubSpot hubs and all tiers, including Free, Starter, Professional, and Enterprise. Any portal with access to the pivot table report type gets frozen columns automatically. There's no tier restriction and no add-on required.
Why did HubSpot freeze pivot table columns by default instead of making it optional?
HubSpot defaulted to frozen columns because the alternative, unfrozen columns, caused consistent readability problems. When labels scroll off screen, humans lose context for the data they're reviewing. Making frozen columns the default removes that friction for every user without requiring anyone to know the setting exists.
How does pivot table column freezing affect dashboard reporting in HubSpot?
Pivot tables displayed on shared dashboards now stay readable regardless of how wide the table is. Stakeholders reviewing dashboards can scroll through multi-column pivot tables and always see which row label and which total correspond to each value. This reduces the need to export data to spreadsheets for review.
Can I turn off frozen columns in HubSpot pivot tables if I don't want them?
Based on the current release notes, frozen columns are on by default and there's no documented toggle to disable the behavior. The feature is designed as a readability improvement for all pivot tables. If your specific use case requires unfrozen columns, check HubSpot's product update page for any configuration options added after launch.
