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:30 AM

That's exactly what I needed, thanks!

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.