Print the first area in landscape and print the second area in portrait.

It'll take two file|prints (and you'll have to change the file|page setup
between prints).

If the ranges don't change, you may want to record a macro when you do the page
setup, print, page setup, print.

Then you can just rerun that macro when you need to do it later.

Kelly wrote:

how do i print both landscape & protrait in the one worksheet in excel?

--

Dave Peterson