print selected sections on the same page

I want to print the column headings and the totals row from a spreadsheet
onto a single page. When I choose the print area from Page setup I get the
headings on one page and the totals on page two, even with print on one page
selected. The same result occurs when I do this from the Print Break View.
The get around would be to copy and paste to a new area of the worksheet, but
I think I should be able to print to a single page without having to do that?

Thanks

Hi ripley

Try
http://www.rondebruin.nl/print.htm#non-contiguous


--
Regards Ron de Bruin
http://www.rondebruin.nl



"ripley" <[email protected]> wrote in message news:[email protected]...
>I want to print the column headings and the totals row from a spreadsheet
> onto a single page. When I choose the print area from Page setup I get the
> headings on one page and the totals on page two, even with print on one page
> selected. The same result occurs when I do this from the Print Break View.
> The get around would be to copy and paste to a new area of the worksheet, but
> I think I should be able to print to a single page without having to do that?
>
> Thanks