Changing page orientation within a worksheet

D

Davo

Does anyone know a way to change from Portrait to
landscape (and vice versa) when printing an excel
spreadsheet?
 
F

Frank Kabel

Hi Dave
if you want to print one worksheet with different page layout you can
try the following:
- start recording a macro
- set the page layout to landscape
- manually print the pages you need in this layout
- change the layout
- print the next pages
- stop recording

there's no way as you have in word to define different page layout for
different paragraphs
 
Top