How do I lock a column in the Numbers program?


macrumors newbie
Original poster
May 6, 2010
Hi, I'm trying to "lock" or "freeze" the first column in the spreadsheet I'm making so that it will always be on the left side of the sheet when I scroll right.
I cannot for the life of me figure out how though. Can anyone help?


macrumors newbie
Sep 29, 2017
There's an icon on the far right of the window. Click on it and you'll see "Freeze Header Columns" and you can vary the number of columns frozen.

Not an easy find. Not very intuitive. Not sure whether I found it in the documentation or possibly here on MR.

Thanks, mysterytramp! Seven years after your post, I wanted to tell you it is *still* valuable! I, too, needed to find how to lock / freeze rows and columns. Much appreciated! Cheers - Matthew
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.