ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   print 2 up in excel (https://www.excelbanter.com/excel-discussion-misc-queries/128683-print-2-up-excel.html)

Sue

print 2 up in excel
 
I have an A5 invoice in excel that I need to print out on A4 - 2 copies of
each invoice per page.

Earl Kiosterud

print 2 up in excel
 
Sue,

It won't do it. Excel, except for a few little niceties like page headings,
rows to repeat at top, etc., prints the sheet as is. You could make a sheet
with linked cells that's laid out the way you want it to print -- two copies
of the invoice, then print that. Select and Copy the invoice cells, then in
the print sheet, do Paste Special - Paste Link. Do the Paste Link into the
two places on the sheet where you want them.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"sue" wrote in message
...
I have an A5 invoice in excel that I need to print out on A4 - 2 copies of
each invoice per page.




Dave Peterson

print 2 up in excel
 
Maybe you could add another printer driver:
http://www.graphicshighway.com/



sue wrote:

I have an A5 invoice in excel that I need to print out on A4 - 2 copies of
each invoice per page.


--

Dave Peterson


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com