5 Replies Latest reply: Jan 5, 2011 8:40 AM by Badunit
sysx Level 1 Level 1
I just started using Numbers after using Microsoft Excel for many years. How can you freeze one or more columns and allow the columns to the right to roll under the columns you freeze? Basically freezing a column and scrolling the remaining columns.

Mac Pro, MacBook Pro, Mac Mini Server, Mac OS X (10.6.2)
  • Jerrold Green1 Level 7 Level 7

    Scrolling with frozen rows or columns in Numbers is different than in Excel. Only Header rows and columns can be frozen. Headers are Top and Bottom rows and Left columns (0-5 in all cases) that have special properties, among them the ability to freeze. Generally speaking, Top Header Rows are intended for Titles, as are Header Columns while Bottom Header Rows are for summary data. When an expression refers to an entire column or row, the Headers are excluded.

  • sysx Level 1 Level 1
    Thanks, that makes sense.
  • TSTURGES Level 1 Level 1
    I have had the same problem; I've read the instructions / Help section many times, and it seems that I should be able to freeze the first column (or several) but when I try that option, what happens is nothing like I expect (based on Excel). Are you saying that it IS possible to hold the left-most column in place when the rest of the spreadsheet is scrolled across? I have not been able to make that happen despite many tries. Thanks very much. If it IS possible would you please expand on the cryptic so-called help screen message?
  • Level 8 Level 8
    Here, applying exactly what is described in the user guide, I get the correct behaviour :

    Yvan KOENIG (VALLAURIS, France) vendredi 5 mars 2010 19:47:33
  • Badunit Level 6 Level 6
    Yes, it is possible to freeze the leftmost column. The column MUST be a header column. You can have up to five header columns and they will all be frozen (or not).

    The table that is in the Blank template has a header column so let's start there.
    Create a new document based on the Blank template.
    Select the table.
    Go to the Table menu and click on Freeze Header Columns.
    That's all there is to it.