Setting Page Setup

[Newt]

I have spreadsheets that I need to print that are in columns that are side by
side. They will not all fit on one page and they differ in length. How do I
set the print boundries to enable these sheets to be printed correctly? When
I set the verticle Page break it stay on the same row across the whole spreat
sheet. Due to this some of the sheets are cut in half?

 

[dlw]

make your left and right margins smaller
use landscape mode

 

[Newt]

I have two different spread sheets I need to print and they are side by side.
I need to use the portrait mode. The spread sheets are different lengths.

 

[Jim Cone]

You can paste into Word and use Format | Columns
-or -
Build your own method...
http://www.mvps.org/dmcritchie/excel/snakecol.htm#snakecols
-or -
Use a commercial add-in... (see below)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming - try "Special Print")



"Newt"
wrote in message
I have spreadsheets that I need to print that are in columns that are side by
side. They will not all fit on one page and they differ in length. How do I
set the print boundries to enable these sheets to be printed correctly? When
I set the verticle Page break it stay on the same row across the whole spreat
sheet. Due to this some of the sheets are cut in half?