Print onto one sheet

**Trick** · 08-31-2006, 04:48 AM

Ive searched for this on the forum and there are numerous topics. HOwever i dont think they quite answer my query...

I have two Charts as separate worksheets.
I select both sheets and go to print - setup and select the multiple page option my printer has - 2 to 1.

I want both charts to appear on one single sheet.

I have done this before in the past but on a different pc and printer, with success.

Anyway, when i print, it prints the one page in portrait (correctly) with the first chart at the top of the page just as i would expect it, but then it leaves the second half of the page empty and continues to print the second selected sheet on a full page.

So i end up with both charts, one in half the size and one in full page size.

This is weird- never seen this before.

Tried it on another printer and it does the same, so im thinking it must be a setting somewhere, or im doing something wrong in excel.

I dont want to paste the charts as an object onto a separate worksheet as this would defeat my objective and take additional time.

Anyone else ever seen this?

**broro183** · 08-31-2006, 05:43 AM

Hi,

I've never been able to print out from separate sheets onto the same page without some manipulation - lucky you! ;-)

Like you say, any extra time needed is a nuisance but to the best of my (small) knowledge a work around of some sort is required. Ron DeBruin has a number of suggestions on his web page http://www.rondebruin.nl/print.htm & I think the closest to what you want would be: http://www.rondebruin.nl/print.htm#non-contiguous (using the picture link technique needs it only needs to be set up once).

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...