- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

OpenOffice Calc Autoformat

Tired of presenting your Calc data in the same old bland manner?

Plain worksheet, cell borders and maybe a font change or two, but basically it’s the same thing over and over again.

If you’re looking for a neat, quick and easy way to present your data with a little more flare then, may I suggest the AutoFormat feature.

After you’ve selected the data you want to format find AutoFormat under the Format menu.


When you make this choice, the AutoFormat dialog box will open.


On the left, you’ll find a list of predefined formats with a preview available in the center section.

If you like one and want all the formatting applied to your data then choose it and click OK.

But… what if you like one but only certain elements such as number formats, borders and fonts then you’ll need to use the More button in the bottom right corner of the dialog box.


Uncheck any aspect of the format that you do not want to include in the changes that Calc will make to your data. (The preview will be updated as you make choices so that you can see what affect each decision has upon the final product.)

When you’re satisfied with your choices, click OK.


The same old data presented in a totally new and awesome manner in almost no time at all.

~ April