How do I lock a column in the Numbers program?

[oujms1]

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?

 

[mysterytramp]

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.

mt

 

[oujms1]

Thanks for that, now to find out how to get that icon to have a drop down arrow (obviously mine does not)............

 

[mysterytramp]

Are you using Numbers 08 or 09? (mine is 09, v 2.0.3)

mt

 

[oujms1]

It's 08, I'm probably boned huh?

 

[mysterytramp]

It's 08, I'm probably boned huh?

Maybe ...

Off the top of my head, you COULD do this ...

Create a separate, one-column table of all your row labels and position that alongside the table with all your data.

mt

 

[TheHypnosisGuy]

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.

mt

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

 

[supermoto1962]

This does not apply to Number 08 - it does not.

 

[Bytesmiths]

Maybe ...

Off the top of my head, you COULD do this ...

Create a separate, one-column table of all your row labels and position that alongside the table with all your data.

Why didn't I think of that?

What I'm trying to do is slightly different, but your idea will probably do the job.

I have a graphic pasted on top of a frozen header column. But it moves as the sheet is scrolled horizontally, instead of sticking to the frozen column.

 

[Dave Braine]

There's an icon on the far right of the window.

Also in the Numbers>Table menu.