Contents
Index 🔎︎

# 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.

Related Topics

Applying Automatic Formatting to a Selected Cell Range