Excel - Portrait and Landscape pages

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
 
F

Frank Kabel

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
 
Top