Using Formatting and Styles in Calc

Calc comes with a few built-in cell and page styles to improve the appearance of your spreadsheets and reports. Although these built-in styles are adequate for many uses, you will probably find it useful to create styles for your own frequently used formatting preferences.

Procedure 3.1. Creating a Style

  1. Click Format+Styles and Formatting.

  2. In the Styles and Formatting window, click either the Cell Styles or the Page Styles icon from the top of the window.

  3. Right-click in the Styles and Formatting window, then click New.

  4. Specify a name for your style and use the various tabs to set the desired formatting options.

  5. Click OK.

Procedure 3.2. Modifying a Style

  1. Click Format+Styles and Formatting.

  2. In the Formatting and Styles window, click either the Cell Styles or the Page Styles icon.

  3. Right-click the name of the style you want to change, then click Modify.

  4. Change the desired formatting options.

  5. Click OK.

To apply a style to specific cells, select the cells you want to format. Then double-click the style you want to apply in the Styles and Formatting window.