Apple’s Worldwide Developers Conference to kick off June 10 at 10 a.m. PDT with Keynote address

The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Freeze header row/column in Numbers not what I'm expecting

I am looking for the Numbers equivalent to freezing panes in Microsoft Excel. I've got a simple spreadsheet with 3 columns of data and a couple of hundred rows of entries in those columns (header column is dates, columns 2 and 3 are data on those days). I highlighted my first row, which has the headers, clicked 'freeze header row', and as I scroll down the spreadsheet, to enter new data, the header row scrolls up along with everything else.


Is this is expected behavior in Numbers?


Is there a different thing I need to do to scroll down and right and have one or two rows/columns with headers stay locked to the top/left of the window?


I'm trying not to pay up for a subscription to Office since I now am able to limit my complex spreadsheets to the work computer, and figure Numbers should handle my simple personal spreadsheet needs.

MacBook Pro (2020 and later)

Posted on Oct 2, 2021 11:50 PM

Reply
Question marked as Best reply

Posted on Oct 3, 2021 12:21 AM

Have you tried to select the row/column and choose Convert to Header Row/Convert to Header Column respectively (through the right click contextual menu)?

2 replies

Freeze header row/column in Numbers not what I'm expecting

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.