Wierd printing requirements between worksheets!

M

mooneh

This may sound strange... I have a form I need to fill in regularly in
excel. However it exists as front page portrait second page (2nd
worksheet) landscape.
Of course when printed it prints individual files per worksheet.
I want to A: print landscape 90 degrees round so it prints in portrait
(bear with me) So i can B: print it duplex on the back of worksheet
A: !!!!!!

any ideas? Am lost! excel 2007
 
S

Shane Devenshire

Hi,

Try this, I can't test the duplex part but

1. Set the first page print area - File, Print Area, Set Print Area
2. Choose File, Page Setup, choose Landscape or Portrait,
3. Choose Fit to 1 page wide by 1 tall, click OK
4. Set the second page print area
5. Set this one to Portrait or Landscape
6. Repeat step 3
7. Select the first and second sheet tabs - Ctrl click the two tabs.
8. Print with your printer set to duplex
 

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

Similar Threads

Printing a workbook but not getting page set-up results 1
excel printing problem 3
Printing Multiple Worksheets on one page 2
Printing report that is portrait and landscape 1
Excel Margin 4
Printing multiple portait and landscape workbooks at the same time 7
Print worksheet 2 on back of worksheet 1, etc.... 1
can i insert a text box in a footer in excel 2003 1

Top