Can I repeat print header Row 5 ONLY in a table .... HOW? (Apple NUMBERS)
I have spent way TOO much time searching for this answer -seems simple but I cannot find one straight forward answer
[Re-Titled by Moderator]
MacBook Pro 15″
When you print, you have an option to repeat the table headers on all pages. Your options are pretty much all or none. Therefore, if your table has 5 header rows, you'll repeat all 5 on each page.
Indirectly, the only way I can think of achieving this is two use two tables - one 'dummy' table with 4 header rows positioned at the top of the sheet, then your actual data table with one header row positioned immediate below.
Align them properly on the page and visually it will look like 5 header rows, but only one table extends onto the second page and has its headers repeated:
which looks like this when printed:
Since Table 1 doesn't extend onto the second page, its headers are not repeated, but Table 2's are.
When you print, you have an option to repeat the table headers on all pages. Your options are pretty much all or none. Therefore, if your table has 5 header rows, you'll repeat all 5 on each page.
Indirectly, the only way I can think of achieving this is two use two tables - one 'dummy' table with 4 header rows positioned at the top of the sheet, then your actual data table with one header row positioned immediate below.
Align them properly on the page and visually it will look like 5 header rows, but only one table extends onto the second page and has its headers repeated:
which looks like this when printed:
Since Table 1 doesn't extend onto the second page, its headers are not repeated, but Table 2's are.
Thanks so much! I follow the just of your response- THANKS!
I have used MS Excel FOREVER and love it but when I updated my OS, I lost my MS Office pkg - no longer supported so I thought I would give Pages and Numbers a good try.... so far my frustrations have been too much to continue but I will give it a little more time. Thanks again
> I have used MS Excel FOREVER
The key difference between Excel and Numbers is that Excel has a monolithic sheet model (one sheet, millions of cells), whereas Numbers takes a sheet and breaks it into multiple tables per sheet.
Sure, you can have one table per sheet and replicate the Excel model, but being able to support multiple discrete tables on a single sheet has certain advantages, and allows for visual tricks such as this header hack.
I appreciate this perspective! I think I need to give it more time before I bail.... Diving head first during tax season when I need to create and update docs in a program that I have to 'search' on-line for answers is very frustrating, but I do understand some of the 'pros' now. I like to do intricate things in my docs content... spending the time to work-around seems it may be worth it! Thanks again
How can I repeat a specific header row in Numbers?
