ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Page Layout in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/73635-page-layout-excel.html)

Kelly

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

Dave Peterson

Page Layout in Excel
 
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


All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com