Page Breaks

[Guest]

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

 

[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

 

[Guest]

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?

 

[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?

 

[Guest]

What is VBA?

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?

 

[Jim Cone]

VBA: Visual Basic for Applications.
It is the programming language used to automate tasks in MS Office programs.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel add-ins... sort colors, compare, arrange columns, thesaurus)




"Cosmo" <[email protected]>
wrote in message
What is VBA?