You've got the sheet open, you're halfway through scrolling, and the column labels have vanished like socks in the wash. Row 1 looked helpful at the start, then suddenly it's gone, and now you're squinting at “Q4 Forecast” wondering which field is which. Excel can fix that, thankfully, and it's one of those tiny moves that makes a messy workbook feel a lot less rude.
The basic trick is simple: freeze a row so it stays visible while you move through the rest of the sheet. Microsoft calls the feature Freeze Panes, and it keeps the rows above and columns left of the selected cell visible as you scroll, which is exactly why it's so handy for large finance files, ops trackers, and reporting sheets in NZ teams. For a broader look at how little spreadsheet tweaks help everyday work feel less clunky, there's a useful local read on improving business productivity with simple tools.
A frozen header row sounds minor until you're knee-deep in a long spreadsheet and every column starts looking like “some number, probably important.” That's when mistakes creep in. A founder checks revenue, an ops lead scans burn, a marketer reviews campaign spend, and each person needs the same thing, a fixed label row that doesn't wander off the top of the screen.
Excel gives you three freeze options, and they're not all doing the same job. Freeze Top Row keeps row 1 visible. Freeze First Column keeps column A visible. Freeze Panes is the flexible one, because it locks whatever sits above and to the left of the cell you choose.
The feature isn't there to make Excel fancy. It's there because spreadsheets get wide and tall fast, especially once a team starts adding notes, filters, sub-headings, and a few too many “temporary” columns. If you're dealing with a shared workbook, a frozen row is the difference between “clear enough” and “where on earth am I?”
Practical rule: if the sheet needs repeated scrolling to identify a column, it probably needs a frozen header.
That's why this isn't just a cosmetic tweak. It's a readability habit, and it makes shared files easier to use across finance, ops, sales, and marketing. If you've ever seen someone scroll back to the top five times in a row, you already know the pain.
If you're on Windows and the header row needs to stay put, Excel gives you a direct route. Open View, choose Freeze Panes, then click Freeze Top Row. That keeps row 1 visible while you scroll, which is exactly what you want when column labels start drifting off screen and everyone in the team begins guessing which number belongs where.
Start on the View tab in the ribbon. Find Freeze Panes, then select Freeze Top Row. Excel handles the rest.
A line appears under row 1 to show the freeze is active. Scroll down, and the top row stays in place while the rest of the sheet moves. It works a bit like pinning the heading row to the top of a long noticeboard, only Excel is a lot less polite about where it hides the button.
The selection rule matters here. Freeze Top Row only locks the first row, while Freeze Panes locks the rows above, and columns to the left, of the cell you choose. That's the part people often miss when they jump straight to the menu and then wonder why the wrong area stayed fixed.
If you are doing the same workbook setup again and again, the keyboard route saves a lot of clicking. On Windows, Alt + W + F + R opens the right ribbon path and freezes the top row. Once you have done it a few times, it becomes much easier to remember than hunting through menus every time.
That shortcut pairs well with the rest of the small time-savers that make spreadsheet work less tedious. If your team lives in Excel, it is worth taking a look at boost productivity with Excel shortcuts.
Quick check: if the line under row 1 is missing, the row is not frozen yet.
Excel's ribbon can shift a little between Microsoft 365 installs and newer builds, which is part of why people swear at it under their breath. The command still sits under View, though, even if the menu layout looks like it was arranged by someone who lost a bet.
Mac users get the same outcome, but the menu can look a bit different, which is where people start muttering at their screens. On Mac, the path is View, then Freeze Panes, then Freeze Top Row. Microsoft also documents Mac-specific instructions for freezing the top row, freezing multiple rows or columns, and choosing a cell like B2 or D5 when you want a bigger freeze area Microsoft for Mac Freeze Panes guide.
Mac users often ask for a shortcut because, fair enough, nobody wants to hunt through menus forever. Microsoft's Mac documentation gives Command + Shift + T for freezing the top row and Command + Shift + F for the full Freeze Panes menu. Those are worth memorising if you're in spreadsheets every day.
There's also one menu item that stands out more on Mac, Freeze First Column. That's useful when you're dealing with wide sheets, especially if column A carries client names, invoice IDs, or project codes.
The important bit is that the logic underneath stays the same. The labels can shift a little between Windows and Mac, but the selection rule doesn't change. That's the part people usually miss, then blame themselves for a menu quirk they didn't create.
On mixed-device teams, the goal isn't “learn Excel once.” It's “know which version you're using before you click.”
That matters a lot for NZ and AU startup teams, because files get bounced between laptops, desktops, and the occasional MacBook in a meeting room. The method should feel familiar, not mysterious.
Freezing row 1 is the easy bit. Freezing row 1 plus a couple of sub-headings, or a header row and a key column, is where people usually get tangled. The trick is not the button. It's the selection rule behind Freeze Panes: Excel freezes everything above and to the left of the cell you've selected.
If you want the first four rows to stay visible, click A5 before using Freeze Panes. Why A5? Because row 5 is the first row you want to keep scrolling, so everything above it gets locked. Same idea for columns. If you want row 1 and column A frozen together, click B2. That leaves the top row above and the first column to the left.
And if you're staring at a dense financial model, D5 is the classic example. That freezes rows 1 to 4 and columns A to C, which is handy when your sheet has a header block plus a few side labels.
That's the whole logic. Once it clicks, the menu stops feeling like random Excel wizardry and starts feeling pretty sensible, which is rare enough to be worth celebrating.
Excel Online can be a bit less forgiving here, especially when teams try to use the same freeze setup across different versions. Microsoft's desktop and Mac guidance is clear, but online workflows can handle the feature differently, so mixed-device teams need to check the version before they assume a freeze will behave the same way. If your team is also trying to smooth out repetitive spreadsheet work, AI business automation in NZ is a decent related topic to explore.
Frozen panes can fail in ways that feel annoyingly quiet. Nothing crashes. Nothing screams. The sheet just doesn't behave the way you expected, and that's worse in some ways because you spend ages second-guessing yourself.
The fix is usually straightforward. Unhide what needs to be visible, remove awkward merged cells if you can, check whether the range became a table, and make sure you're not using Split by mistake. That last one gets people more often than they'd like to admit.
If the freeze line looks wrong, check the sheet structure before you click anything else.
A short troubleshooting habit saves a lot of backtracking. It also helps when files are passed between colleagues who've each “tidied” the sheet in their own way, which is a polite way of saying they've all made different messes.
Frozen panes are easy to remove once you know where Excel hid the button. Go to View, then Freeze Panes, then Unfreeze Panes. Excel keeps that setting with the workbook, so the same spot in the ribbon handles both the setup and the clean-up without making you hunt through a maze of menus.
If you want the freeze to stay in place after reopening the file, save the workbook as .xlsx. That is Excel's standard workbook format, and it is the safest place for freeze settings to live. If the sheet moves into another platform, such as Google Sheets or Excel Online, the frozen row can behave differently or disappear at the boundary.
That catches people out when files are shared across investors, contractors, or mixed-device teams. The freeze did not fail. The software changed, and each app handles the sheet a little differently.
A monthly investor update often has a long financial summary with repeated line items, and frozen headers keep that sheet readable without endless scrolling. A shared cohort tracking sheet is a different beast, but the same rule applies. Marketing and product teams still need the filter row visible so they can scan cohorts, dates, and notes without losing the thread.
Keeping those sheets tidy also fits with broader business process automation benefits, because fewer manual fixes means less time spent rescuing the same workbook every week. For teams setting up files that other people will open, edit, and pass around, that is one small spreadsheet habit that saves a lot of head-scratching later.
Add your NZ or Australian app or tech company to the NZ Apps directory and get discovered by founders and operators across the region.
Get ListedReach tech decision-makers across New Zealand and Australia. Sponsored and dofollow editorial links, permanent featured listings, and sponsored articles on a DA30+ .co.nz domain.
See Options