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

Problem with printing a word document containing a table 0
Landscape selected but printout persists in portrait. How to fix? 1
Word Printing and Rotation of Landscaped Pages 2
excel printing problem 3
Printing 2
Printing landscape and portrait 3
Printing a workbook but not getting page set-up results 1
Single column not printing 0

Top