10 Replies Latest reply: Sep 13, 2008 10:49 PM by Mursaydees
guyvitetta Level 1 (0 points)
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 (15,825 points)
    This option is not available in Numbers.

  • Gnarlodious Level 4 (3,220 points)
    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.
  • jt519 Level 2 (295 points)
    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.
  • Thomas Wright1 Level 2 (165 points)
    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.
  • Level 8 (41,790 points)
    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)
  • ChrisB1 Level 1 (0 points)
    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.
  • Ric Donato Level 4 (1,105 points)
    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.

  • Kyd Level 1 (30 points)
    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.
  • inStitches Level 1 (0 points)
    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.
  • Mursaydees Level 1 (0 points)
    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!