Pritning 2 selected areas of a sheet

[PaulHelyer]

Hi,

I have an excel sheet with titles and summary data at the top of a sheet, then a long list of data (rent collections -amount date etc)going down the page. This list is for monthly collection so gets longer with time as I add to it.

I need a printout on a single sheet of paper displaying the summary data at the top, then in the available space below the most recent rent collections.

In other words on screen the summary will always be shown and the collections will scroll as I keep adding to it, so when I print, what is printed is what is on screen.

I think it is something to do with split screen (just below summary data at top) then being able to set the print window so it is not static, it prints what is shown on screen

thanks

Paul

[NAVEEN]

Dear PaulHelyer,

Open your excel file and click on file menu, click on page setup and click
on "Sheet" tab. Under the "Print titles" you will find a text box "Rows to
repeat at top:". Here type the address of the cells that contain your titles
and summary (instead of typing address you can select it by mouse click
also). Click on OK Button.

Now it will print the titles summary and whatever the cells you select below
those titles.

Thanks.
Bye.
NAVEEN

"PaulHelyer" wrote:

>
> Hi,
>
> I have an excel sheet with titles and summary data at the top of a
> sheet, then a long list of data (rent collections -amount date
> etc)going down the page. This list is for monthly collection so gets
> longer with time as I add to it.
>
> I need a printout on a single sheet of paper displaying the summary
> data at the top, then in the available space below the most recent rent
> collections.
>
> In other words on screen the summary will always be shown and the
> collections will scroll as I keep adding to it, so when I print, what
> is printed is what is on screen.
>
> I think it is something to do with split screen (just below summary
> data at top) then being able to set the print window so it is not
> static, it prints what is shown on screen
>
> thanks
>
> Paul
>
>
> --
> PaulHelyer
> ------------------------------------------------------------------------
> PaulHelyer's Profile: http://www.excelforum.com/member.php...o&userid=31716
> View this thread: http://www.excelforum.com/showthread...hreadid=514189
>
>