View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone
 
Posts: n/a
Default Page Break Problem

Suggest you try Page Break Preview on the View menu.
In there, you can drag and drop page breaks.
Solid lines are manual page breaks and the dotted lines are
the automatically created ones.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"top.jimmy"
wrote in message

Can do that, but I want each one to print automatically with a page break.
My other worksheets within the same workbook aren't having problems inserting
page breaks. Is it because each scoresheet is exactly the same???

"Jim Cone" wrote:
Set a separate print area for each scoresheet.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware




"top.jimmy"
wrote in message...
I've created a worksheet within a workbook that has four scoreheets. I've set
the print area for the whole worksheet but I want each scoresheet to print on
its own piece of paper. I've Reset the Print area and tried to no avail to
place Page Breaks that will separate the individual scoresheets.
Any help or ideas would be greatly appreciated.