Thanks, Ron.

I didn't notice the part about xl2007.

Ron de Bruin wrote:

another) is there a command? thx i am using excel 2007

For the OP

Insert a new sheet
copy the first range to be printed.

On the Home tab in the first group click on the arrow on the Paste button

Choose: "As Picture" and then "Paste Picture link"

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
You may be able to use this technique:

Insert a new sheet
copy the first range to be printed.
go to A1 of the new sheet
Shift-Edit|Paste picture link

Repeat for each range to be printed and paste under (or to the right) of the
pasted pictures.

Then print this new worksheet.

By pasting a picture link, if the original data changes, so will the picture.

Joe wrote:

How do I print multiple excel pages on one sheet of paper? (i.e. one after
another) is there a command? thx i am using excel 2007

--

Dave Peterson

--

Dave Peterson