Headers in Numbers 6.2.1 (Mac)

Hi Claire,

"Also if I select the particular row to change to a header- for example row 5, I cannot see an option to convert the row into a header.

If you have already converted rows 1, 2, 3 and 4 to Header rows, you will see the option to do the same with row 5.

"Header rows" must be at the top of the table, and contiguous.

You can place "headings" at the top of each section of the table, but they will be 'headings' in format only, and will not have any of the properties of Header rows or Header columns.

For these, I copied (option-command-C) the format of a cell in row 1 (a Header row), then pasted tht format (option-command-V) into all the cells in rows 6 and 13. Visually, they give the impression of 'header rows,' but functionally, they are ordinary 'body' rows.

Take a look at Categories, and Smart Categories. I'm not sure they will fit what you are trying to do, but they may.

Regards,

Barry

Hi Claire,

Header rows in a table are exactly that. They are always at the head of a table, never in the middle. Numbers allows a maximum of 5 Header rows in each table (always at the top of a table).

Likewise, Footer rows are always at the foot of a table.

The good news is that we can use the "Charm of Numbers".

Instead of an "ocean" of a sheet that includes "islands" of data here and there, we can place several tables on the "canvas". Each table can have a distinct purpose.

What is your overall aim?

Regards,

Ian.