View Single Post
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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.