How do I lock a column in the Numbers program?

Discussion in 'Mac Apps and Mac App Store' started by oujms1, May 6, 2010.

  1. oujms1 macrumors newbie

    Joined:
    May 6, 2010
    #1
    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?
     
  2. mysterytramp macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #2
    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
     

    Attached Files:

  3. oujms1 thread starter macrumors newbie

    Joined:
    May 6, 2010
    #3
    Thanks for that, now to find out how to get that icon to have a drop down arrow (obviously mine does not)............
     

    Attached Files:

  4. mysterytramp macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #4
    Are you using Numbers 08 or 09? (mine is 09, v 2.0.3)

    mt
     
  5. oujms1 thread starter macrumors newbie

    Joined:
    May 6, 2010
  6. mysterytramp macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #6
    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
     
  7. TheHypnosisGuy macrumors newbie

    TheHypnosisGuy

    Joined:
    Sep 29, 2017
    #7
    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
     

Share This Page