Print excel sheet in one page

[ketan]

I have a long set of data in two column in a excel sheet. The print
runs in several pages. Print occupies only half page and leaves half
page blank. How can I print two pages on same page so that no of
papers reduces to half?

Regards,

 

[Chrissy]

You can set up another worksheet in the same workbook that
has formula in it to link to your original workbook. You then
print that workbook.

Chrissy.


ketan wrote

 

[GarethG]

ketan

Just to point out that this is not a programming issue and is therefre
in the incorrect forum, but here is the solution.

Select the entire range of information. Go to file>Print Area>Set
print area
Then go to File>Page Setup

A dialog appears, select the 'Page' tab and select the best orientation
(long list select portrait)
The select "Fit to Page" This defaults to 1 page high by one page
long. This will cram everything onto one page.

NB This solution is based on Excel 2000


Gareth

 

[Tom Ogilvy]

Another approach is to see if you printer supports "UP" options, such as 2
UP.

2 UP puts two pages on one page using the print driver. 4 UP puts 4 printed
pages on 1 page.

This would be the easiest.

If not, as was suggested, you would need to create another page using
formulas that would set up 4 columns from the two columns.

there have been many posts asking this question. Another alternative is to
use a macro. David McRitchie has documented some code to do this on his
site:

http://www.mvps.org/dmcritchie/excel/snakecol.htm#joining

 

[ketan]

Thanks all of you. "UP" option worked. In fect the link suggested by
Tom Ogilvy is much more helpful. Thanks again.
Regards,
Ketan