AutoFormat /text/shared/01/AutoFormat.xhp tables;AutoFormat function sheet table;AutoFormat function styles;table styles AutoFormat function for tables

AutoFormat Styles

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

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 the table. Choose a predefined AutoFormat to apply to a selected area in your sheet.

Add

Adds a new table style to the list. Format a table in your document. Select the table, and then choose Table - AutoFormat Styles. Click Add. In the Add AutoFormat dialog, enter a name, and then click OK. Enter a name for the new AutoFormat, and then click OK. 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 style. You cannot delete the default style.

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

Lists the available formatting styles for tables. Click the format that you want to apply, and then click OK.

Number format

Includes numbering formats in the selected style.

Borders

Includes border styles in the selected style.

Font

Includes font formatting in the selected style.

Pattern

Includes background styles in the selected style.

Alignment

Includes alignment settings in the selected style.

AutoFit width and height

When marked, specifies that you want to retain the width and height of the selected cells of the selected format.