PRINTING HELP!?

[Guest]

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

 

[Guest]

Select the first sheet to print and then hold the control key down while you
click on each of the tabs (where the sheet name is at the bottom) that you
want to print.

As some additional info, you can also use the page setup and have a common
header and page numbers etc also if you do the above first.

I think that the print area for each sheet has to be set individually.

Regards,

OssieMac

 

[Guest]

Sorry. My answer might not be what you want. It puts each worksheet on
separate pages.

Regards,

OssieMac

 

[Guest]

Hi,

No. It is not possible.

Challa Prabhu

 

[Dave Peterson]

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.

 

[Ron de Bruin]

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"

 

[Dave Peterson]

Thanks, Ron.

I didn't notice the part about xl2007.