Sisällys
Hakemisto 🔎︎

# AutoFormat

Use this command to apply an AutoFormat to a selected sheet area or to define your own AutoFormats.

Toiminnon käyttäminen:

Choose Format - AutoFormat Styles.

On the Tools bar, click

Automaattinen muotoilu

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.

### Esikatselukenttä

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.

### Poista

Poistetaan valittu määrä osatekijöitä vahvistuskyselyn jälkeen.

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

Aiheeseen liittyvää

Automaattisen muotoilun käyttö taulukoissa