Using both Landscape and Portrait page formats in the same sheet.

S

Strawberrie

Hello,

Would anyone happen to know how to change the formatting of pages in a worksheet to allow the printing of both landscape and portrait pages without having to cut and paste pieces of the data into another sheet.

Any help would be greatly appreciated.

Ps. I know that Word does this task. So is there something available in Excel.
 
R

rbanks

I think what you're trying to do is print several different sections i
the same sheet, some portrait, some landscape.

The easiest way to do this is, for each page or section that you wan
to print, create a "Custom view" All printing information is save
withing a view.

Then simple select [view][Custome views][show] to switch between th
views.

It is very simple using the record macro function to record a macr
that shows each view, prints, then returns to the master view.

Good luc
 
D

Dave Peterson

You could record a macro when you do it manually.

Select your range to print and orientation), print it, then select the next
range/orientation and print once more.

Then whenever you needed this, just replay that macro.
 
Top