ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to change default page size in Excel (https://www.excelbanter.com/excel-worksheet-functions/33642-how-change-default-page-size-excel.html)

proshail

How to change default page size in Excel
 
How do i change the default margins and page sizes in Excel..

Dave Peterson

Create a workbook with every setting you want--always create backup checked,
maybe page layout, headers/footers???

Then save it as book.xlt (as a template) in your XLStart folder.

Then when you click on the new icon, that new workbook will inherit all those
settings from that template.

ps. If you create a template workbook named Sheet.xlt and store it in the same
folder, that one will be used when you add new worksheets to existing workbooks.

proshail wrote:

How do i change the default margins and page sizes in Excel..


--

Dave Peterson

proshail

Thanks Dave, got it.

"Dave Peterson" wrote:

Create a workbook with every setting you want--always create backup checked,
maybe page layout, headers/footers???

Then save it as book.xlt (as a template) in your XLStart folder.

Then when you click on the new icon, that new workbook will inherit all those
settings from that template.

ps. If you create a template workbook named Sheet.xlt and store it in the same
folder, that one will be used when you add new worksheets to existing workbooks.

proshail wrote:

How do i change the default margins and page sizes in Excel..


--

Dave Peterson



All times are GMT +1. The time now is 12:36 PM.

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