Printing

[Marianne]

Hi,

I have two documents, each with one spreadsheet. I would like to print the
documents on the same page, back to back. Is there a way to do this without
printing one page and then putting the paper back in the printer to print?

Thank you

 

[~L]

The exact options vary from printer to printer.
You must have a device capable of two-sided printing (may also be called
duplexing).

For the Excel side, copy all of the data you want to print into one
workbook, then go to view > Page Break View or in Excel 2007 the view tab and
page break view

Inspect your document to make sure no data is outside of the print area and
that the print area has no blank pages (it should be apparent if this is the
case if you are in page break view and you will be able to drag the page
borders if you need to).

From there go to file > print to bring up the print options then hit
'properties'

From this point on, the exact steps will vary depending on your printer.

 

[Shane Devenshire]

Hi,

As stated, you would need to do a screen capture of one of the sheets and
paste that into the other spreadsheet. This is assuming that by two
different spreadsheets you mean two different files, not two sheets in the
same workbook.

 

[LiAD]

Thanks for the ultra quick answers!

I have 4 tables within one sheet in one excel file which i need to print 50
times to get the 200. On each table in cell S6, AS6, S59 and AS59 I need a
sequential number going from 1-4 on the first sheet printed, (one number per
table that is), 5-9 on the second etc.

Within the print options I can see nothing at the moment that would do this.

Am I missing something?

 

[LiAD]

Sorry just realised that somebody titled their post the same as mine so iwas
reading the wrong one - hence why it didnt work for me.

Sorry