Prev: Printing selected pafes in Excel 2007
Next: How do I see PDF comments in Excel insert object
From: Bob on 15 Apr 2010 12:44
I have clicked select all sheets and selected two sided copy in print
options. It gives me a message that 1 page has been printed, when I hit
print, but when I go to the printer, there are two sheets of paper. Each
spreadsheet on its own piece of paper. i have done this before, but when I
do I print several copies, and months go by before I have to print the two
sheets front and back again. Help.
From: FSt1 on 15 Apr 2010 13:08
hi
technically all excel does is send the data. seems to me the problem may be
in your printer, not excel. make sure that you are printing to a duplex
printer.

regards
FSt1

"Bob" wrote:

> I have clicked select all sheets and selected two sided copy in print
> options. It gives me a message that 1 page has been printed, when I hit
> print, but when I go to the printer, there are two sheets of paper. Each
> spreadsheet on its own piece of paper. i have done this before, but when I
> do I print several copies, and months go by before I have to print the two
> sheets front and back again. Help.
From: dlw on 15 Apr 2010 16:20
we run into something similar trying to print multiple sheets to one PDF.
Instead of getting a PDF with two pages, you end up with two PDF files. It
has something to do with Excel sending each page as a different print job.
Anyway, the following procedure fixes it for some reason:
1. Ctrl or shift click to select all the sheets you want to print
2. go File/Page Setup
3. re-select the DPI in Print Quality by picking the same thing again
try the print again
it might work?


"Bob" wrote:

> I have clicked select all sheets and selected two sided copy in print
> options. It gives me a message that 1 page has been printed, when I hit
> print, but when I go to the printer, there are two sheets of paper. Each
> spreadsheet on its own piece of paper. i have done this before, but when I
> do I print several copies, and months go by before I have to print the two
> sheets front and back again. Help.
 | 
Pages: 1
Prev: Printing selected pafes in Excel 2007
Next: How do I see PDF comments in Excel insert object