In Numbers Spreadsheet, how to make titles/first row stick?

Discussion in 'Mac Applications and Mac App Store' started by sun surfer, Jun 30, 2012.

  1. macrumors regular

    Joined:
    Jun 6, 2010
    #1
    I'm doing a large spreadsheet with many columns and hundreds of rows that I need to input info for. Each column is titled in the first row but the problem is that I necessarily am jumping around to input the info to various rows and unless it's one of the first few rows, I can't tell which column is which because the first row of column titles is not showing. As a lot of rows are similar numbers, this is a problem, so every time I have to scroll to the top and be positive which column I'm putting the info in.

    Is there any way to make the first row stick so that even when you scroll, it stays in view though the others don't? Or is there something similar I can do to make titles for each row always viewable? Thanks.
     
  2. macrumors regular

    Joined:
    Feb 8, 2008
    #2
    i believe what you want is the icon directly under the Media icon at the top.

    if you mouse over it - is called "Choose the number of header rows and when they display"

    select the Repeat Header Rows on Each Page option from the pulldown.
     
  3. thread starter macrumors regular

    Joined:
    Jun 6, 2010
    #3
    That's perfect! THANK YOU so much yukio! :D

    It was under that option, it's the "freeze rows" option under that icon. You're a lifesaver!
     
  4. macrumors newbie

    Joined:
    Feb 13, 2013
    #4
    Thanks as well!!
     

Share This Page