Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Printing more than one worksheet area

How do I print different worksheet block selections on one page?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 364
Default Printing more than one worksheet area

"Horace" wrote in message
...
How do I print different worksheet block selections on one page?


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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Printing more than one worksheet area

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.

Horace wrote:

How do I print different worksheet block selections on one page?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing On One Page Using Print-Area whynot Excel Discussion (Misc queries) 6 October 2nd 07 07:11 PM
Print Area Printing David New Users to Excel 3 August 22nd 07 10:18 PM
how to get the doted printing area as default Sam Farid Excel Worksheet Functions 1 October 19th 06 12:29 AM
Automated Dynamic Printing Area? smplogc Excel Discussion (Misc queries) 9 April 30th 06 05:13 PM
Printing - Have to set print area 1 column further than necessary STUART BISSET Excel Discussion (Misc queries) 0 January 24th 05 07:59 PM


All times are GMT +1. The time now is 01:27 PM.

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

About Us

"It's about Microsoft Excel"