Applying Automatic Formatting to a Selected Cell Range
You can use the AutoFormat feature to quickly apply format 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
. -
Select which properties to include in an AutoFormat.
-
Click \<emph\>OK\</emph\>.
The format is applied to the selected range of cells.
If you do not see any change in color of the cell contents, choose \<item type=\"menuitem\"\>View - Value Highlighting\</item\>.
To Define an AutoFormat for Spreadsheets or Ranges
You can define a new AutoFormat that is available to all spreadsheets and ranges.
-
Format a sheet or range.
-
Choose
or select the formatted range. -
Choose
. -
Click \<emph\>Add\</emph\>.
-
In the \<emph\>Name\</emph\> box of the \<emph\>Add AutoFormat\</emph\> dialog, enter a name for the format.
-
Click \<emph\>OK\</emph\>.