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 .
-
Select which properties to include in an AutoFormat.
-
แแแแฌแแแแฃแแแ แแแแแขแแแแแ.
The format is applied to the selected range of cells.
If you do not see any change in color of the cell contents, choose .
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 .
-
แแแแฌแแแแฃแแแ แแแแแขแแแแแ.
-
In the Name box of the Add AutoFormat dialog, enter a name for the format.
-
แแแแฌแแแแฃแแแ แแแแแขแแแแแ.