Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Revenger
 
Posts: n/a
Default Print 3 sheets on the same page

Hi,
I have the following problem:
I have 3 worksheets with 5 rows of data on each worksheet. Now, I want to
print all three sheets on the same page (5 rows from the first sheet,
followed by 5 rows from the second sheet and finally 5 rows from the third
sheet).
Can this be done without using the macro and copying data on the first
sheet ?
Thanks !
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone
 
Posts: n/a
Default Print 3 sheets on the same page

R,

You can use the "copy picture" feature to copy a picture of
each selection and paste it on a separate sheet, from which
you print. Press the shift key while clicking the "Edit" menu
to see the copy picture menu item.
Or--
The free Excel add-in "Print Selections Only" may be able to do
what you want. It can be downloaded here...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


"Revenger"
wrote in message

Hi,
I have the following problem:
I have 3 worksheets with 5 rows of data on each worksheet. Now, I want to
print all three sheets on the same page (5 rows from the first sheet,
followed by 5 rows from the second sheet and finally 5 rows from the third
sheet).
Can this be done without using the macro and copying data on the first
sheet ?
Thanks !
  #3   Report Post  
Posted to microsoft.public.excel.misc
Revenger
 
Posts: n/a
Default Print 3 sheets on the same page

On Tue, 17 Jan 2006 06:52:45 -0800, Jim Cone wrote:

Or--
The free Excel add-in "Print Selections Only" may be able to do
what you want. It can be downloaded here...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


Jim,
that's exactly what I needed !
Thank you very much !

R
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone
 
Posts: n/a
Default Print 3 sheets on the same page

R,
You are welcome, appreciate you letting me know.
Jim Cone


"Revenger" wrote in message...

On Tue, 17 Jan 2006 06:52:45 -0800, Jim Cone wrote:
Or--
The free Excel add-in "Print Selections Only" may be able to do
what you want. It can be downloaded here...
http://www.realezsites.com/bus/primitivesoftware
Jim Cone
San Francisco, USA


Jim,
that's exactly what I needed !
Thank you very much !

R
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
How to print multiple columns on same page ocpsduke Excel Discussion (Misc queries) 2 October 8th 05 06:19 PM
How to print 2 Excel pages side by side on 1 printed page? Kathy Install Excel Discussion (Misc queries) 1 September 29th 05 05:03 PM
tOTALS WON'T PRINT ON SAME PAGE annes519 New Users to Excel 2 June 3rd 05 11:12 PM
My scaling is set to print 1x1 pages. But it prints 1000's of page Graeme Excel Worksheet Functions 0 March 23rd 05 01:15 AM
print selected sections on the same page ripley Excel Discussion (Misc queries) 1 February 22nd 05 04:04 PM


All times are GMT +1. The time now is 06:31 PM.

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

About Us

"It's about Microsoft Excel"