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.

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.

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.