If same sub-headings for each page, use FilePage SetupSheetRows to repeat
at Top.
Select the top 4 rows and OK.
If sub-headings are different for separate sections(pages) then I would
suggest setting manual Page Breaks.
Gord Dibben Excel MVP
On Thu, 17 Feb 2005 13:19:08 -0800, SWeyer
wrote:
Is there a way to tag rows in Excel so that they stay together (same page)
when printing? I have sub heading rows in a spreadsheet that I would like to
make sure stay with the subsequent rows when I print it, instead of leaving
some one one page and the others on the next.
|