Operation Manual

AutoFormat of cells
Using AutoFormat
You can use Calc’s AutoFormat feature to format a group of cells quickly and easily.
1) Select the cells in at least three columns and rows, including column and row headers, that
you want to format.
2) Go to Format > AutoFormat on the Menu bar to open the AutoFormat dialog (Figure
122).
3) Select the type of format and format color from the list.
4) If necessary, click More to open Formatting if Formatting is not visible.
5) Select the formatting properties to be included in the AutoFormat function.
6) Click OK.
Figure 122: AutoFormat dialog
Defining a new AutoFormat
You can define a new AutoFormat so that it becomes available for use in all spreadsheets.
1) Format the data type, font, font size, cell borders, cell background and so on for a group of
cells.
2) Go to Edit > Select All on the Menu bar to select the whole spreadsheet.
3) Go to Format > AutoFormat to open the AutoFormat dialog and the Add button is now
active.
4) Click Add.
5) In the Name box of the Add AutoFormat dialog that opens, type a meaningful name for the
new format.
6) Click OK to save. The new AutoFormat is now available in the Format list in the AutoFormat
dialog.
146 | Getting Started with LibreOffice 5.0