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.

Automaatvorminduse rakendamine lehele või valitud lahtrivahemikule

  1. Vali lahtrid, mida soovid vormindada, koos veergude ja ridade päistega.

  2. Vali Vormindus - Automaatvormindus.

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

  4. Klõpsa Sobib.

    Vormindus rakendatakse valitud lahtrite vahemikule.

Märkuse ikoon

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


To Define an AutoFormat for Spreadsheets

You can define a new AutoFormat that is available to all spreadsheets.

  1. Format a sheet.

  2. Choose Edit - Select All.

  3. Choose Format - AutoFormat.

  4. Klõpsa Lisa.

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

  6. Klõpsa Sobib.