print on both sides problem

J

Jamie

I have a workbook with 8 tabs. When I print the workbook I want it to print
a total of 4 pages, front and back alternating tabs. I have the tabs set up
identically, but when I print it only the first 4 tabs print on both sides.
The next 4 tabs all print on their own sheet of paper.
 
D

Dave Peterson

Just a guess...

On the offending worksheet, is there a chance that you have an extra (empty)
column(s) or row(s) included in the print range.

Maybe it's just outside of what prints on the first page, but since there's
nothing in those columns/rows, the sheet looks empty???

If you do View|Page break preview (xl2003 menus), it may be obvious.
 
J

Jamie

No that was not it, but I did figure it out. I had print on both sides
checked, but for whatever reason that did not work. I had to go to print
preview and while in that view I had to click on options and then click on
pront on both sides. I did that very thing from the normal view and it did
not work. I had to do it from the print preview view and I had to do it for
each individual tab. Thank you for your response.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top