Page Breaks

C

Cosmo

Is there anyway to set the number of lines in a page break? I have some very
large price sheets with pictures in them and when I set sizing it cuts
pictures where the page breaks end up
 
J

Jim Cone

Go to the View menu and select "Page Break Preview".
Click and drag the page break lines to where you want them.
Exit by selecting "Normal" on the View menu.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Cosmo" <[email protected]>
wrote in message
Is there anyway to set the number of lines in a page break? I have some very
large price sheets with pictures in them and when I set sizing it cuts
pictures where the page breaks end up
 
C

Cosmo

I have 50+ pages, is there a way to set a pre detrmined number of cells per
page so I dont have to drag the line on each page?
 
J

Jim Cone

You only have to adjust the page breaks for the sections you are
concerned about. The other pages automatically adjust.

As for setting a fixed amount of rows to print on every page,
there is no way that I know of without using VBA.
With that one could set a manual page break every N rows.

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



"Cosmo" <[email protected]>
wrote in message
I have 50+ pages, is there a way to set a pre detrmined number of cells per
page so I dont have to drag the line on each page?
 
C

Cosmo

What is VBA?

Jim Cone said:
You only have to adjust the page breaks for the sections you are
concerned about. The other pages automatically adjust.

As for setting a fixed amount of rows to print on every page,
there is no way that I know of without using VBA.
With that one could set a manual page break every N rows.

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



"Cosmo" <[email protected]>
wrote in message
I have 50+ pages, is there a way to set a pre detrmined number of cells per
page so I dont have to drag the line on each page?
Click to expand...
 
Top