Proper Use of Header and Footer Cells In Numbers

Header and Footer rows and columns have special properties in Mac Numbers. They label the cells in the body of a table, and also exclude themselves from calculations. You can scroll and print with better results using headers too.

Comments: 4 Responses to “Proper Use of Header and Footer Cells In Numbers”

    John Gardner
    1 year ago

    Thanks for the Video on Numbers Heades and Footers - great! Especially for this like me painfully converting from Excel to Numbers.
    I would like to add some information to either the Header or Footer when printing:
    1. The current date and time (to be automatically updated)
    2. The file information of the Spreadsheet: Name, Path, Tab

    thanks for your help and keep well

    1 year ago

    John: Don't confuse the "headers" and "footers" for printing with table headers and footers. Completely separate things. You can access the print headers and footers for each page when you go to print a document. You can put anything you want in there. https://support.apple.com/en-us/HT202981

    David Shemuel
    1 year ago

    Like John G (above) - I miss ability to add Headers/Footers available in Excel. One really useful feature was to be able to automatically insert Path/File Name (&Path/&File/&Sheet), plus (updateable) Date & Time - the link Gary provied (thanks, Gary) does not discuss File Name (automatic) .....

    Robert Kunes
    1 year ago

    I, too, like to have a cell in my spreadsheets that shows the path and file name. I am still not clear on whether there is a way to do that in numbers.

Comments Closed.