Create Custom Worksheet Templates: MS Excel

Dennis Faas's picture

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!

Rate this article: 
No votes yet