Table Formatting Page 2 3 etc not working

[mikerules]

I have attached a file and the question is on the Purchase Order Tab.

I have set up Table Formatting for the first time and not sure if I have this right. I setup Table Formatting on cells B21 to L22 and checked header. I assume everything above B21 will form part of the header on each page and the totals Below L22 will only show on the last page?

I added additional rows to take me down below where a 2nd page should start to test the header and it does not seem to carry to page 2. It seems to just make page 1 crazy long?

Can someone tell me where I have gone wrong?

Thanks,

Mike

[oeldere]

Although I don't understand your question complete.

If you want to show your headers on all pages

Page => Print Title => sheets => row above each page $1:$19


If you want to show the headers Always in your sheet

View => block titles
In this case I blocked the titles from row 20.

See the attached file.

[mikerules]

Ok Thanks Oeldere. I had originally thought the header would be automatically set based on the setting made at table formatting but I have corrected this now. Thanks for taking the time to help me out.

Mike