Applying Automatic Formatting to a Selected Cell Range
You can use the AutoFormat feature to quickly apply a format to a sheet or a selected cell range.
To Apply an AutoFormat to a Sheet or Selected Cell Range
-
Select the cells, including the column and row headers, that you want to format.
-
Choose
. -
To select which properties to include in an AutoFormat, click More.
-
Click OK.
The format is applied to the selected range of cells.
![Note Icon Note Icon](6.1/media/icon-themes/help/note.png)
If you do not see any change in colour of the cell contents, choose
.To Define an AutoFormat for Spreadsheets
You can define a new AutoFormat that is available to all spreadsheets.
-
Format a sheet.
-
Choose
. -
Choose
. -
Click Add.
-
In the Name box of the Add AutoFormat dialogue, enter a name for the format.
-
Click OK.