Show All

Settings you can save in a template

Formatting

• Cell and sheet formats. Set by using the commands on the Format menu.
• Page formats and print area settings for each sheet.
• Cell styles.
• The number and type of sheets in a workbook.
• Protected and hidden areas of the workbook. You can hide sheets, rows, and columns and prevent changes to worksheet cells.

Text, data, graphics, and formulas

• Text you want to repeat, such as page headers and row and column labels.
• Data, graphics, formulas, charts, and other information.
• Data validation settings.

Toolbars, automation, and Option settings

• Custom toolbars, macros, hyperlinks, and ActiveX controls on forms. To make a custom toolbar available, attach the toolbar to the template.
• Workbook calculation options and window view options. Set with the Options command (Tools menu).