Possible to have various sections of worksheets print on 1 page?

[Respite Barb]

Excel question

Because of drastic formatting differences in a document, I've created
sections of a document on 3 worksheets. On the first page of the print-out I
need all three sections to print on page 1. Is it possible to do this in
excel and how? Thanks for your help.

 

[Luke M]

You're probably going to want to use the camera tool, as this is the easiest
way to group different sections of a workbook altogther for printing. The
cool thing is the picture link updates in real time, as opposed to a static
picture.

How to:
Copy the section of cells you want to "photograph".
Navigate to the section of your workbook you want to see the photo.
Holding down Shift, goto Edit, then click on Paste Picture Link

Voila! You now have a camera shot/window looking at another part of your
workbook. Repeat with other sections of your workbook, and move the picture
links around to create the desired print-out.

Note: (In XL 2003) If you want to use this feature alot, you can add the
camera button to one of your toolbars. Go to Customize Toolbar dialogue, and
look under the Tools menu bar options. The Camera is about 3/4 of the way
down.