Create Custom Worksheet Templates: MS Excel

  • by Carol Bratt on 20060414 @ 12:29AM EST | google it | send to friends
  • Filed under Carol's Corner Office | (related terms: create, custom template, custom header, print settings, file)

When you print a worksheet in Excel, do you find yourself adding the same header and footer and resetting the same print options every time?

For example, suppose you require that all worksheets are printed with the company's custom header and set to print in landscape mode. Each time you create a workbook, you will need to change the default print settings, unless you create a custom template that will automatically give you the appropriate settings.

Here's how to create a custom template:

  1. Launch MS Excel.
     
  2. Open a blank document; select all sheets.
     
  3. Go to File | Page Setup.
     
  4. In the Orientation section, select Landscape, and then click OK.
     
  5. In the Header and Footer section, you can either select a header from the Header drop-down menu, or you can press the Custom Header button to create your header.
     
  6. Click OK.
     
  7. Go to File | Save As.
     
  8. Under File Name, enter a name for your template.
     
  9. Under Save As Type, select Template and click Save.

Now when you create a workbook based on your custom template, the header and print settings will automatically be set to your specifications.

Visit Carol's web site to learn more tips like this one!