Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the defaults for Page Setup in Excel?
For all new spreadsheets...
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the defaults for Page Setup in Excel?
Start a new workbook. Do all the stuff you like for each worksheet in that
workbook. Save it as a template file named book.xlt in your XLStart folder. Each time you click on the new icon on the standard toolbar, that new workbook will inherit all the settings from that template file. If you want new worksheets added to existing workbooks to have these same settings, set up another workbook template file (one sheet only???) and name it sheet.xlt. Save it in the same XLStart folder. Val wrote: For all new spreadsheets... -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the defaults for Page Setup in Excel?
Once I figured out where the XLStart file was located, your solution worked
great! Thanks! One thing though, a few times I selected "template" the path was changed to Document & Settings, etc....and new sheet did not change. After a few of tries, all is OK. Thanks again Dave! Val "Dave Peterson" wrote: Start a new workbook. Do all the stuff you like for each worksheet in that workbook. Save it as a template file named book.xlt in your XLStart folder. Each time you click on the new icon on the standard toolbar, that new workbook will inherit all the settings from that template file. If you want new worksheets added to existing workbooks to have these same settings, set up another workbook template file (one sheet only???) and name it sheet.xlt. Save it in the same XLStart folder. Val wrote: For all new spreadsheets... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
Is there a way to apply "page setup" defaults to an existing work. | Excel Discussion (Misc queries) | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel |