Excel - Portrait and Landscape pages

  • Thread starter Thread starter hcj
  • Start date Start date
H

hcj

Can you have a combination of both portrait and landscape pages in
worksheet ? I suppose that the page setup setting applies uniformly fo
all pages in the worksheet ? How you could get around this ? Than
you.

CJ
 
Hi
you're right: You can have only ONE orientation per
worksheet at the same time. One workaround for printing:
- tsart recording a macro
- set the page orientation for the first part of your sheet
- print the desired pages
- change the page orientation
- print the remaining pages

Now use this recorded macro for printing
 
You must log in or register to reply here.

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

Landscape selected but printout persists in portrait. How to fix? 1
Printing landscape and portrait 3
Word Printing and Rotation of Landscaped Pages 2
Landscape Portrait 2
Wierd printing requirements between worksheets! 1
Printing a workbook but not getting page set-up results 1
Orientation Landscape but want Page #s to Print Portrait 1
Printing report that is portrait and landscape 1

Back
Top