ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   changing default page layout (https://www.excelbanter.com/setting-up-configuration-excel/133085-changing-default-page-layout.html)

Anne Ryan

changing default page layout
 
I would like to change my page layout so that every time I open a new excel
sheet it is landscape form rather than portrait. Can this be done? how?

Dave Peterson

changing default page layout
 
Start a new workbook.
Set up everything you want--headers/footers/layout...
Save it as book.xlt in your XLStart folder.

Then excel will use that when you create a new workbook by clicking on the new
icon on the standard toolbar.

If you want the same thing when you add a new worksheet to an existing workbook,
save another workbook (probably a single sheet???) in that same XLStart
folder--but name it Sheet.xlt.

Anne Ryan wrote:

I would like to change my page layout so that every time I open a new excel
sheet it is landscape form rather than portrait. Can this be done? how?


--

Dave Peterson


All times are GMT +1. The time now is 06:22 PM.

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