Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.

Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >

You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

How to Freeze Columns in Numbers?

I have not figured out how to freeze columns in numbers v 11.2 by using these instructions. Changing the number of columns to freeze has no effect.



MacBook Air (2020 or later)

Posted on Nov 9, 2021 7:51 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 9, 2021 1:36 PM

There is no "freeze columns" function in Numbers.

There is no "freeze rows" function in Numbers.


The two functions that are provided are:


Freeze Header columns

and

Freeze Header rows.


The table shown in your screen shot contains two Header rows, and at least one Header column, and may have more, but these are hidden behind the open menu.


These would be the only rows and column(s) to freeze (stay on screen as you scroll the table up or to the left.)


Regards,

Barry

3 replies
Question marked as Top-ranking reply

Nov 9, 2021 1:36 PM in response to dtryon9981

There is no "freeze columns" function in Numbers.

There is no "freeze rows" function in Numbers.


The two functions that are provided are:


Freeze Header columns

and

Freeze Header rows.


The table shown in your screen shot contains two Header rows, and at least one Header column, and may have more, but these are hidden behind the open menu.


These would be the only rows and column(s) to freeze (stay on screen as you scroll the table up or to the left.)


Regards,

Barry

Nov 9, 2021 8:05 AM in response to dtryon9981

dtryon9981 wrote:

I have not figured out how to freeze columns in numbers v 11.2 by using these instructions. Changing the number of columns to freeze has no effect.


Your screenshot suggests you are trying to change the number of rows, not columns. You should get the result you want by changing the number of columns.


SG

How to Freeze Columns in Numbers?

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