The Format menu allows users to control the formats of cells, columns, rows, worksheets and the workbook. This menu also gives users access to templates of standard formats.
Cells — The Cells... menu item opens a sub-menu with choices to allows the user to modify the formatting of the selected cells.
Column — The Column menu item opens a sub-menu with choices to allows the user to modify the view of the selected columns.
Row — The Row menu item provides the same functions as the Column menu item but operates on rows.
Sheet — The Sheet menu item opens a sub-menu with operations to change properties of the worksheet. This submenu has three sections.
The first section contains menu items used to modify sheets indirectly. Note that these items are also available from the context menu which appears by clicking (usually with the right mouse button) on one of the worksheet tabs.
The second section contains various toggle menu items used to switch sheet properties directly.
Zoom... — The Zoom menu item opens a dialog which allows the user to set the magnification of all worksheets in the current workbook. This item is also included in the View menu discussed in Section 4.2.4 ― The View Menu,
Autoformat... — This menu item opens the autoformat dialog to give user access to a list of format templates. Format templates are useful for users who are often filling out tables in a particular format. The user picks an area of the worksheet into which they want to apply the template. Most templates define headers and footers so the selection area must be big enough to fit those template elements and the user's data. The template will not affect data which has already been input into a worksheet.
The dialog has two tabs: Preview and Template Details. The details are simply information about the template. The Preview tab has three main options: a Settings menu, an Edit menu and a category chooser. The settings menu allows a user to pick what parts of the template they want to copy into the worksheet. The edit menu will be used to create new templates. Currently templates are written as text into an extensible markup language (XML) format. The category chooser gives the user access to different groups of templates. Templates in each category are displayed in the middle area of the dialog. Users select the template they want to use by clicking on it. The currently selected template is highlighted with a red boundary which may be hard to see.