Autoformat

The Autoformat feature in Calc is used to assign preset formats to a range of cells - creating attractive, professional-looking table designs at the press of a button.

In the ‘before’ picture below, we have a rather bland table.Time to spice it up. Obvious approach is to do it manually - selecting groups of cells in turn and applying different formats. The micromanagers among us probably favor that approach.

There is a ‘quick-and-dirty’ alternative - namely the Autoformat feature.

The Autoformat feature can be used to assign preset formats to a range of cells. Boder styles, number formats etc can all be configured and reused for different tables.

First, select the cells you want to format. From the menu, select Format - AutoFormat

In the Autoformat dialog box, select the desired Autoformat…

The end result. A prettier table with little or no effort.

One Response to “Autoformat”

  1. John Doe Says:

    Sorry, but the default designs of any templates whatsoever in OpenOffice are just plain ugly. I’d rather take the time to select my own colors than autoformat a table to balck and dark blue.

Leave a Reply