Skip navigation
This discussion is archived

Freeze Panes

6917 Views 10 Replies Latest reply: Sep 13, 2008 10:49 PM by Mursaydees RSS
guyvitetta Calculating status...
Currently Being Moderated
Jun 1, 2008 6:58 PM
Does Numbers v1.0.2 permit me to Freeze Panes like in Excell? If so, how?
Mac Book Pro Intel, Mac OS X (10.5.2), Numbers 1.0.2
  • WWJD Level 6 Level 6 (15,815 points)
    Currently Being Moderated
    Jun 1, 2008 6:58 PM (in response to guyvitetta)
    This option is not available in Numbers.

    MDD Dual 1GHz 2GB RAM / QS 867MHz 1.5GB RAM, Mac OS X (10.5.3), 2930 SCSI / 16x DVR-110D / Yamaha 01X / 1GB Shuffle x 2 / 4GB Nano :o)
  • Gnarlodious Level 4 Level 4 (3,220 points)
    Currently Being Moderated
    Jun 2, 2008 3:44 PM (in response to WWJD)
    I don't think it is even necessary in Numbers. You just drag the size of thr grid you need. It's a lot easier than Excel.
    2.4 MBP, Mac OS X (10.5.3)
  • jt519 Level 2 Level 2 (285 points)
    Currently Being Moderated
    Jun 3, 2008 4:57 PM (in response to Gnarlodious)
    It's very necessary, IMO. Try having a large table of data that you're entering. As you fill in the table down, your top title row has now scrolled off the top and you have no idea which column you are in.

    Same thing if the window scrolls to the right, you have no idea which row you are in.

    Sure you can change the scale to print, then you have a printout that you need a magnifying glass to read.
    PowerMac G5 2x2, MacBook Pro 2.66, Powerbook G4 1.67mhz, Mac OS X (10.5)
  • Thomas Wright1 Level 2 Level 2 (165 points)
    Currently Being Moderated
    Jun 3, 2008 5:57 PM (in response to jt519)
    While Numbers doesn't allow you to freeze panes that include multiple rows or columns, if all you want to do is keep track of which column or row you are viewing, create a table that has a header row and a header column -- or add them if an existing table doesn't have these headers. Then choose Show Print View. You will then see that the header column and header row are included at the top and left of every page.
    20-inch mid-2007 iMac, Mac OS X (10.5.3)
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    Jun 4, 2008 1:16 AM (in response to jt519)
    Here we are end users trying to help end users.
    Is it really useful to repeat for the hundred's time the same grind?

    Freeze panes is not available PERIOD

    If you want it:
    _Go to "Provide Numbers Feedback" in the "Numbers" menu_, describe what you wish.
    Then, cross your fingers, and wait _at least_ for iWork'09

    Yvan KOENIG (from FRANCE mercredi 4 juin 2008 10:16:46)
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
  • ChrisB1 Calculating status...
    Currently Being Moderated
    Jun 6, 2008 11:23 AM (in response to KOENIG Yvan)
    What a bummer! I cannot understand why they would not provide this function, that I would think is an essential element of all spreadsheets. Simplicity is a beautiful ting, but ... wow! What were they thinking? Here I am, HIGHLY motivated to not have to use Microsoft products, and highly loving Apple products, and I can't imagine how I would use this product. I have a very simple cash flow spreadsheet, and I just need to put values in for "rent" in each first of the month column .. and I can't do it without scrolling up to the top every time? That's ridiculous.
    MacBook Pro, Mac OS X (10.5.3)
  • Ric Donato Level 4 Level 4 (1,085 points)
    Currently Being Moderated
    Jun 6, 2008 1:57 PM (in response to ChrisB1)
    Hi to jt519, guyvitetta, and ChrisB1,
    Welcome to Numbers discussions.

    Freezing columns/rows is arguably the most asked question in this forum. Prior to posting that question using this forums search feature would have provided you the answer to your question. My suggestion is to first use Search Discussions.

    Follow Yvan's post contact Team Numbers request to have freeze columns/rows in the next version. They won't answer however, along with many others that have sent them that same request yours will be there as well. The more the merrier, maybe in the next version it will be added perhaps.

    These Discussions are enduser helping enduser, not Apple employees answering questions. Discussing whether something is important or unimportant, a reason why something was not included or was included in a application is a exercise in futility. Voice concerns to the Numbers Team—many times I have sent them my requests as well.

    Again, welcome to Numbers Discussions, have fun here.

    17" iMac 1GHz with 1 GB RAM, iBook 466 Clamshell SE 320 RAM, Airport Extreme base station, Mac OS X (10.4.11)
  • Kyd Calculating status...
    Currently Being Moderated
    Jun 6, 2008 3:19 PM (in response to ChrisB1)
    If all you need is the header when putting in entries at the bottom of the table, create a second table with just the headers and put it at the bottom of the primary table. As you add entries to the primary table, it'll push the new "header table" down.

    Doesn't help with entries in the middle of the sheet, but would in this one case.
    MacBook Pro, Mac OS X (10.5.3)
  • inStitches Calculating status...
    Currently Being Moderated
    Jul 5, 2008 11:40 AM (in response to jt519)
    use the print view to work on the page you want to make changes or view--it shows the headers and footers on each page.
    macbookPro, Mac OS X (10.5.3)
  • Mursaydees Calculating status...
    Currently Being Moderated
    Sep 13, 2008 10:49 PM (in response to inStitches)
    Thank you so much for advising on the "Print View" method of seeing my headers on each page. That's all I wanted to do.

    I never found that Microsoft's "Freeze Pane" ever worked that well, anyways. It was constantly freezing the wrong line, or forgetting it was frozen. This is much better!
    Black MacBook, Mac OS X (10.5.4)


More Like This

  • Retrieving data ...

Bookmarked By (0)


  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.