Setting up page template
How do you set up a page template so that when I go to print a worksheet, I
don't have to reset the orientation as landscape, reset margins, and the like? I have a workbook, and everytime I add a worksheet, I now copy another worksheet and paste it on the new worksheet, but all of the page set up formatting is at default on the new page. |
Create a workbook template named Sheet.xlt with a single
worksheet. Set up your printing preferences on this worksheet and save the file in your XLStart directory (typically C:\Program Files\Microsoft Office\Office\XLStart). Excel will use this as a template when creating new worksheets. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "John Sullivan" wrote in message ... How do you set up a page template so that when I go to print a worksheet, I don't have to reset the orientation as landscape, reset margins, and the like? I have a workbook, and everytime I add a worksheet, I now copy another worksheet and paste it on the new worksheet, but all of the page set up formatting is at default on the new page. |
All times are GMT +1. The time now is 05:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com