Printing problem

[MikeB]

Excel 2007, Windows Vista Ultimate SP 2.

I have data on two sheets in the same workbook. I need to print this
data on the front and the back of a single sheet of duplex print
paper. To do this, I need to create a PDF (I also tried this with the
MS XPS Writer in my Vista Ultimate). I cannot print the paper, I need
to email the PDF to various recipients that will receive and print the
file themselves.

I select the two sheets by holding down Ctrl and clicking on both
sheets.

Then in Print Preview, I can see two pages containing the selected
areas of the two sheets that I need to print. The areas on both sheets
are marked with the Set Print Area command/button/dialog.

When I now select Print, then I get multiple print dialogs, one for
each sheet and I get separate PDF (or XPS) files, one for each sheet.
This makes it impossible to print the sheets duplex.

Anyone here have advice or help or can point me to what I am doing
wrong or am missing or whatever?

Thanks!

 

[MikeB]

Excel 2007, Windows Vista Ultimate SP 2.

I have data on two sheets in the same workbook. I need to print this
data on the front and the back of a single sheet of duplex print
paper. To do this, I need to create a PDF (I also tried this with the
MS XPS Writer in my Vista Ultimate). I cannot print the paper, I need
to email the PDF to various recipients that will receive and print the
file themselves.

I select the two sheets by holding down Ctrl and clicking on both
sheets.

Then in Print Preview, I can see two pages containing the selected
areas of the two sheets that I need to print. The areas on both sheets
are marked with the Set Print Area command/button/dialog.

When I now select Print, then I get multiple print dialogs, one for
each sheet and I get separate PDF (or XPS) files, one for each sheet.
This makes it impossible to print the sheets  duplex.

Anyone here have advice or help or can point me to what I am doing
wrong or am missing or whatever?

Thanks!

More info. I suspect that this might have something to do with the
print margins in the worksheet. It seems that the two sheets have
different print margins. If that is the case, or even if it just
might be, then I'd like to try and reset the print margins for the
entire worksheet and see if it resolves the problem. Any hints on how
I can get to reset the print margins on the different sheets to the
default or to use the same values for both?

Thanks.

 

[Pete_UK]

If you group both sheets, then whatever you do to one will be
reflected on the other, so if you select Page Setup and adjust the
margins it will apply to both sheets.

Hope this helps.

Pete

 

[MikeB]

If you group both sheets, then whatever you do to one will be
reflected on the other, so if you select Page Setup and adjust the
margins it will apply to both sheets.

Hope this helps.

Pete

I messed up something else. Setting the margins equivalent on the two
pages didn't seem to have had an effect, except now I get a 3rd, blank
PDF file as the first of three PDFs that print as a result of the
Print command. If I preview I see only two pages and the print dialog
says printing 2 pages as well...

Ack!

This is *so* frustrating.

My Print options on the print dialog are as follows:

Print Range: All
Print What: Active Sheets with the Ignore Print Areas *un*checked.

 

[ebloch]

Why not keep it simple and copy both sheets to a third sheet with a Page
Break between them?

Or use the free ASAP Utilities which has a function to print multiple
sheets.

Eric

 

[MikeB]

Thanks for your advice, and I'm sure it is useful, I have never before
heard of the ASAP utilities.

I don't know what was wrong in my spreadsheet, but I copied the stuff
into a new file and printing works as I was expecting.

Somewhat easier than installing the ASAP utilities and more do-able
than copying the material to a single sheet with a page break - the
column spacing on the two sheets are not similar.

These days the Office products are so complex that I doubt people can
figure out what goes wrong in them.

-Mike