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

On the Tools bar, click

AutoFormat

## 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 dialog then appears.

Enter a name and click OK.

## Delete

Deletes the selected element or elements after confirmation.

## Rename

Opens a dialog where you can change the name of the selected AutoFormat.

The Rename AutoFormat dialog 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, deselect 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.