print 2 up in excel

S

sue

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

Earl Kiosterud

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.
 
Top