How to print 2 sheets on one page

[wideEyedPupil]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I'm not an excel user normally (Numbers!) but I'm trying to help a friend.

He has a sheet which would be better split into 2 sheets because it would be easier to format with different column widths for different part of the data.

If he separates sheet1 into 2 sheets, can these be printed on the same page one above the other (like in Numbers, insert sheet would)?

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I'm not an excel user normally (Numbers!) but I'm trying to help a friend.

He has a sheet which would be better split into 2 sheets because it would be
easier to format with different column widths for different part of the data.

If he separates sheet1 into 2 sheets, can these be printed on the same page
one above the other (like in Numbers, insert sheet would)?

You want to print two Worksheets, but want them both on one hardcopy
page?

The first thing I'd try is simply formatting your output (via the
printer setup boxes) to print "two pages per sheet" and then telling the
print dialog (and/or Excel) to print " all selected worksheets"