Printing Multiple sheets on ONE?

[onesidered]

Hello all...

I am trying to print 8 sheets on one paper...

(EXAMPLE)

SHEET 1
A B C D
1XXXX XXXX XXXXX XXXX
2XXXX XXX XXXX XXXX
3XXX XXXX XXXX XXXX
4XXXX XXX XXXX XXXX
5XXXX XXXX XXXX XXXX

SHEET 2
A B C D
1XXXX XXXX XXXXX XXXX
2XXXX XXX XXXX XXXX
3XXX XXXX XXXX XXXX
4XXXX XXX XXXX XXXX
5XXXX XXXX XXXX XXXX

Because I only have like 5-6 lines per sheet i want to condense them into one page

thanks.

T.

[Dave Peterson]

Maybe you can just create a new worksheet and copy|paste special values from
each worksheet to that new worksheet and print from there.

In fact, you can copy the data as a picture and only have to do it once.

Select your range
edit|copy
select A1 of that new worksheet
shift-edit|Paste picture Link

Repeat (but paste under each picture).

Notice that if you change any of the real data, the picture also changes.

Then just print those pictures.

onesidered wrote:
>
> Hello all...
>
> I am trying to print 8 sheets on one paper...
>
> (EXAMPLE)
>
> SHEET 1
> A B C D
> 1XXXX XXXX XXXXX XXXX
> 2XXXX XXX XXXX XXXX
> 3XXX XXXX XXXX XXXX
> 4XXXX XXX XXXX XXXX
> 5XXXX XXXX XXXX XXXX
>
> SHEET 2
> A B C D
> 1XXXX XXXX XXXXX XXXX
> 2XXXX XXX XXXX XXXX
> 3XXX XXXX XXXX XXXX
> 4XXXX XXX XXXX XXXX
> 5XXXX XXXX XXXX XXXX
>
> Because I only have like 5-6 lines per sheet i want to condense them
> into one page
>
> thanks.
>
> T.
>
> --
> onesidered
> ------------------------------------------------------------------------
> onesidered's Profile: http://www.excelforum.com/member.php...o&userid=25977
> View this thread: http://www.excelforum.com/showthread...hreadid=394382

--

Dave Peterson

[onesidered]

Dave, you are the MAN... that worked out great..


I did the Paste Special > Values.

Thanx,
T.