Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chirag Dedhia
 
Posts: n/a
Default Print multiple A5 pages on A4 paper

I have my page setup as A5. But i want to print multiple A5's on an A4 or A3.
How do i go about with this??
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chirag Dedhia
 
Posts: n/a
Default Print multiple A5 pages on A4 paper

Someone please help me with this soon!

"Chirag Dedhia" wrote:

I have my page setup as A5. But i want to print multiple A5's on an A4 or A3.
How do i go about with this??

  #3   Report Post  
Posted to microsoft.public.excel.misc
Manoj
 
Posts: n/a
Default Print multiple A5 pages on A4 paper

A work-around==

Copy the contents you want to paste...Go to another sheet and press the
{shift} key before pressing the {Edit} menu... there you will find a menu
item {Paste picture link}. Similarly copy and paste the other 4 or 5 orr as
many ranges you want on this sheet. Then set the print area that includes
all these ranges and print it on one single sheet in A3. The advantage of
this is that the changes in the original ranges will automatically get
reflected here online.

See if this works.

"Chirag Dedhia" wrote:

I have my page setup as A5. But i want to print multiple A5's on an A4 or A3.
How do i go about with this??

  #4   Report Post  
Posted to microsoft.public.excel.misc
Andrew Taylor
 
Posts: n/a
Default Print multiple A5 pages on A4 paper

Your printer driver may have a feature to support this kind of
formatting:
click Prefences on the Print dialog and then "Advanced" (or similar).


Chirag Dedhia wrote:
I have my page setup as A5. But i want to print multiple A5's on an A4 or A3.
How do i go about with this??


  #5   Report Post  
Posted to microsoft.public.excel.misc
Chirag Dedhia
 
Posts: n/a
Default Print multiple A5 pages on A4 paper

Manoj I tried your method, though it works, it doesn't serve the purpose i
want it to.

Andrew, i think i'll test this on another printer. Hope it has such settings
to print multiple pages on one Paper.

"Andrew Taylor" wrote:

Your printer driver may have a feature to support this kind of
formatting:
click Prefences on the Print dialog and then "Advanced" (or similar).


Chirag Dedhia wrote:
I have my page setup as A5. But i want to print multiple A5's on an A4 or A3.
How do i go about with this??

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
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
Print a range on multiple worksheets on one sheet of paper? RoyalStreet Excel Worksheet Functions 2 March 1st 06 04:25 PM
Print pages in a different order dlb1228 Excel Discussion (Misc queries) 2 February 23rd 06 09:31 PM
Print Odd/ Even or specified pages in excel at a time. NAVEEN Excel Discussion (Misc queries) 1 February 21st 06 11:07 AM
Print Odd/ Even or specified pages in excel at a time. NAVEEN Excel Discussion (Misc queries) 0 February 21st 06 10:31 AM


All times are GMT +1. The time now is 12:54 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"