Header row is Numbers

Using Numbers, you don't. Numbers supports up to 5 header rows, up to 5 header columns and up to 5 footer rows. Those are fixed limits.

Can you rework your tables to use fewer than six header rows?

Your other option is to Provide Numbers Feedback (Numbers menu item) and request a feature enhancement increasing the number of header rows possible. I would not expect rapid action, though.

Regards,

Barry

Simple. Split it into two tables. Table 1 is your summary table, and only includes the first 14 rows of the table you showed above. The rest is Table 2, with row 16 set as its header. This will appear on every printed page, as you desire, but not the first (summary) page.

There are few features that Numbers has which you cannot get with Excel, but the ability to have more than one table in a Sheet is one such feature. Take advantage of it.

Hi brq123,

Making a Summary table with the title "Between Minimum and Maximum" and then using rows 4-14 in the body of the table would be a nice presentation. Your data table would start with the current row 16. Having actual header columns can make searches and filters much easier too.

quinn

On the left I have 5 header rows and needed 8. By incorporating line breaks, I was able to rework this table on the right to contain 8 header lines, in only 4 header rows.

On iOS I just tap the cell while typing and choose “Insert” then “Line Break” to add a line break, which operates the same way as hitting “return” within a word processor such as Pages.

So you want a different header on each printed page? I would not use headers for this at all, as they are, by definition, constant across all pages. You would need to go into page setup and identify your top row on each printed page, then add whatever formatting you desire to those rows, which would be body rows, and use those as your headers. Using body rows as headers adds new challenges, such as messing with formulas that sum columns, etc. You would need to create a hidden column such as “page header” that contains 1, or TRUE, or whatever, if the row is a page header, and use SUMIF rather than sum on the column, to exclude these rows from calculations.

Hi Brian,

Glad to help. It should look nice.

quinn