ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   default page size (https://www.excelbanter.com/excel-programming/276976-re-default-page-size.html)

Robert Rosenberg

default page size
 
The page sizes come from your printer. You can make one the default by
choosing it in a blank new workbook (on all of the worksheets) and save the
workbook as a template with the name Book.xlt. When saving it, make sure it
appears in your XLStart folder on your hard drive.

Also, save another workbook with only one worksheet with your default page
size and save it as a template with the name Sheet.xlt and also place it in
XLStart. This second template is used when inserting worksheets within
workbooks.

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel

"Mr. Chan" wrote in message
...
Any method to create a new page size such as A4, A3 for
selecting in Page Setup in all new file?

Thanks,





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

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