A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2010, 07:01 PM posted to microsoft.public.excel.worksheet.functions
Respite Barb
external usenet poster
 
Posts: 6
Default Possible to have various sections of worksheets print on 1 page?

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
  #2  
Old April 28th, 2010, 07:51 PM posted to microsoft.public.excel.worksheet.functions
Luke M[_4_]
external usenet poster
 
Posts: 451
Default Possible to have various sections of worksheets print on 1 page?

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" wrote in message
...
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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.