MacMost Now 724: Numbers Headers and Footers

Learn to use header and footer rows in iWork Numbers. Footers allow you to easily perform functions, like sums and averages on entire columns. Headers can remain at the top of the screen as you scroll. Both can be used to keep calculations and titles separate from sorted data in the body of a spreadsheet.

Comments: 14 Responses to “MacMost Now 724: Numbers Headers and Footers”

    Michael
    7 years ago

    Thanks Gary for another useful tip. I already used it today:)

    Jan E.
    7 years ago

    Hi, is it possible to have more than one Footer in the same spreadsheet?, for instance one for the first X rows, another for another group of rows etc. etc.

    Eric
    7 years ago

    Gary,
    Dittos. Another great set of tips!

    Michael A.
    7 years ago

    Hi Gary –
    As a seasoned excel user, this tip about headers and footers for iWork Numbers is great and a big time saver. Thanks.

    Judy
    7 years ago

    Great tip. Used it already

    Gary Stone
    7 years ago

    Dear Gary,

    Very good tutorial, I have been wondering for some time about header rows, header columns, and footers. Your insightful video cleared it up for me.
    Thanks!

    Brian M
    7 years ago

    Gary,
    I want to freeze the header rows and columns on a particular spreadsheet, but the Freeze option does not appear – only “Repeat Header Rows/Columns on Each Page.” Oddly enough, the Freeze option does appear on other spreadsheets. Any idea why?

    Thanks for all the great tips.

      7 years ago

      Not sure. Hard to tell without seeing it. Play around and try to figure out the differences.

      ajtoelle
      7 years ago

      You probably have “print view” enabled for the sheet. in Numbers, “repeating headers/columns” and “frozen headers/columns” are controlled by the same setting. The term & behavior that you see on a given table is determined by how the sheet is being viewed. A table with frozen headers becomes a table with repeating headers, when print view is enabled.

    betsy
    7 years ago

    how do you add a footer row to all of my sheets. The doc. I am working on has 60 different sheets. I don’t want to have to add it to each different sheet.

      7 years ago

      You can’t add a footer to every sheet with one command.
      60 sheets? That’s a huge amount. I can’t imagine having 60 different types of data in a single document.

    betsy
    7 years ago

    This was originally an excel program and I got a new computer. When it was transferred it dumped it into numbers. It is individual accounts. thanks for your help. I am so thankful I found your information videos.

      7 years ago

      Interesting. Perhaps time for a re-design of the spreadsheet document? If there are 60 accounts, then in a spreadsheet they should be in a single sheet of 60 rows. Of course if the idea is to use each sheet as a form — well that’s using Excel/Numbers in a different way, I guess. Typically you would do that in a database program (like Bento) not a spreadsheet.

Comments Closed.