Show All

Hide All

Formatting

• Cell and sheet formats. Set by using the commands on the Format menu.
• Page formats and print area (print area: One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed.) settings for each sheet.
• Cell styles (style: A combination of formatting characteristics, such as font, font size, and indentation, that you name and store as a set. When you apply a style, all of the formatting instructions in that style are applied at one time.).
• 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 (macro: An action or a set of actions you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.), hyperlinks (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.), and ActiveX controls (ActiveX control: A control, such as a check box or button that offers options to users or runs macros or scripts that automate a task. You can write macros for the control in Microsoft Visual Basic for Applications or scripts in Microsoft Script Editor.) 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).