Possible to have various sections of worksheets print on 1 page?
in [Functions]
|
From: Respite Barb on 28 Apr 2010 14:01 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. -- Respite Barb
From: Luke M on 28 Apr 2010 14:51 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. -- Best Regards, Luke M "Respite Barb" <RespiteBarb(a)discussions.microsoft.com> wrote in message news:B05A758B-AAF4-4A82-916D-4E1C29462D56(a)microsoft.com... > 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. > -- > Respite Barb
|
Pages: 1 Prev: Average IFS (Multiple Criteria) Next: Average IFS (Multiple Criteria) |