Thread: Printing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
~L ~L is offline
external usenet poster
 
Posts: 177
Default Printing

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.

"Marianne" wrote:

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