Printing more than one worksheet area

S

Stephen

Horace said:
How do I print different worksheet block selections on one page?
Click to expand...

As far as I know, you can only achieve this by copying the data you want
printed into adjacent areas of another worksheet and then printing that
worksheet.
 
D

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.
 
Top