AutoFormat
Use this command to apply an AutoFormat to a selected sheet area or to define your own AutoFormats.
To access this command...
Choose Format - AutoFormat Styles.
On the Tools bar, click
AutoFormat
The AutoFormat command is available only if a cell range with at least 3 columns and 3 rows are selected. Otherwise this command will appear grayed out in the menu.
Format
Choose a predefined AutoFormat to apply to a selected area in your sheet.
Preview Field
Displays a preview of the current selection.
Add
Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats. The Add AutoFormat dialogue box then appears.
Enter a name and click OK.
Delete
Deletes the selected element or elements after confirmation.
Rename
Opens a dialogue box where you can change the name of the selected AutoFormat.
The Rename AutoFormat dialogue box opens. Enter the new name of the AutoFormat here.
Formatting
In this section you can select or deselect the available formatting options. If you want to keep any of the settings currently in your spreadsheet, unmark the corresponding option.
Number format
When marked, specifies that you want to retain the number format of the selected format.
Borders
When marked, specifies that you want to retain the border of the selected format.
Font
When marked, specifies that you want to retain the font of the selected format.
Pattern
When marked, specifies that you want to retain the pattern of the selected format.
Alignment
When marked, specifies that you want to retain the alignment of the selected format.
AutoFit width and height
When marked, specifies that you want to retain the width and height of the selected cells of the selected format.