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

  1. Select the cells, including the column and row headers, that you want to format.

  2. Choose Format - AutoFormat.

  3. To select which properties to include in an AutoFormat, click More.

  4. Smelltu á Í lagi.

    The format is applied to the selected range of cells.

Táknmynd fyrir athugasemd

If you do not see any change in color of the cell contents, choose View - Value Highlighting.


To Define an AutoFormat for Spreadsheets

Þú getur skilgreint nýtt útlit sem sjálfformun.

  1. Format a sheet.

  2. Choose Edit - Select All.

  3. Choose Format - AutoFormat.

  4. Smelltu á Bæta við.

  5. In the Name box of the Add AutoFormat dialog, enter a name for the format.

  6. Smelltu á Í lagi.