Problem with long spreadsheets when printing

[jenni]

When you have a table in Excel, that only has two or three columns width, but extends over 90 some pages...and only<br>uses up the left hand side of the page, can Excel continue the table first on the right hand side before it moves to the next page? I don't want to cut and past 90 some pages.&nbsp;&nbsp;Is there some type of automatic feature in Excel for<br>something like this?<br>Thank you

 

[Garridon]

Not sure if this will help, but you can try it and see what happens:<br><br>Open the spreadsheet.&nbsp;&nbsp;Select File&lt;Page Set Up.&nbsp;&nbsp;Click on the Page option tab.&nbsp;&nbsp;Under the Scaling section, change the percentage to a lower number.&nbsp;&nbsp;You can go to Print Preview and see how it looks and make further adjustments.<br> <p>Linda Adams<br><a href=mailto:Garridon@aol.com>Garridon@aol.com</a><br><a href=

http://www.geocities.com/hallona_2000>Linda

Adams Online</a><br>I'm a professional writer, published internationally.

 

[jenni]

Garridon,<br>I tried your suggestion out, but it only shrinks the table, instead of automatically moving the data to the right hand side of the page.&nbsp;&nbsp;Thanks anyway.&nbsp;&nbsp;

 

[aug4570]

jenni, any possibility of importing that information into an access database?&nbsp;&nbsp;access' report feature will allow you to use both sides of the page under Page setup/columns tab.&nbsp;&nbsp;select 2 columns and the down,then across column layout.&nbsp;&nbsp;you may have to adjust your report margins.

 

[habfan]

have you heard of a product called fineprint.&nbsp;&nbsp;It can be located at <A HREF="

http://www.fineprint.com.&nbsp"

TARGET="_new">

http://www.fineprint.com.&nbsp</A>;&nbsp;It

will allow you to print upto 8 pages on one sheet.&nbsp;&nbsp;If you adjust your page width you will not need to reduce the size of your print and will save some trees.<br><br>There is a trial version on the site.<br><br>Peter Coghill<br><A HREF="mailtoeter_Coghill@hotmail.com">Peter_Coghill@hotmail.com</A><br><br>