2 Replies Latest reply: Feb 18, 2013 11:11 PM by Jerrold Green1
m6000 Level 1 Level 1

In Appleworks, a spreadsheet column heading can be locked so that it is not altered with organizing the column.  How is this done in Numbers?


iMac, OS X Mountain Lion (10.8)
  • Barry Level 7 Level 7

    The default tables in the "Blank" templates in numbers contain one Header Row and one Header column. These rows and columns have special properties, including the ability to be 'frozen' in place as the rest of the table is scrolled.

     

    Place your headings in a Header Row or a Header Column.

     

    In the Table menu, you'll find "Freeze Header Rows" and "Freeze Header columns."

     

    "Freeze" does not apply in Print view, where Header Rows and Columns are repeated on each 'page'.

     

    Regards,

    Barry

     

    PS:For more on header and Footer rows/columns (and other features of Numbers), read the first four chapters of the numbers '09 User Guide. You can download the guide via the Help menu in Numbers'09. search "freeze" for more on freezing header rows, etc.

  • Jerrold Green1 Level 7 Level 7

    In addition to what Barry said, header rows are never affected by sorting, regardless of being Frozen for Scrolling.

     

    Jerry