/text/scalc/01/05110000.xhp AutoFormat Use this command to apply an AutoFormat to a selected sheet area or to define your own AutoFormats.

Format Choose a predefined AutoFormat to apply to a selected area in your sheet. 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. More Opens the Formatting section, which displays the formatting overrides that can be applied to the spreadsheet. Deselecting an option keeps the format of the current spreadsheet for that format type. 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. Rename Opens a dialog where you can change the specification of the selected AutoFormat. The button is only visible if you clicked the More button. The Rename AutoFormat dialog opens. Enter the new name of the AutoFormat here. More Closes the Formatting options section, if it is currently open.