Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Selecting Themes for Sheets

Office Calc comes with a predefined set of formatting themes that you can apply to your spreadsheets.

It is not possible to add themes to Calc, and they cannot be modified. However, you can modify their styles after you apply them to a spreadsheet.

Before you format a sheet with a theme, you have to apply at least one custom cell style to the cells on the sheet. You can then change the cell formatting by selecting and applying a theme in the Theme Selection dialogue box.

To apply a custom cell style to a cell, you can open the Styles window and, in its lower list box, set the Custom Styles view. A list of the existing custom defined cell styles will be displayed. Double click a name from the Styles window to apply this style to the selected cells.

To apply a theme to a spreadsheet:

  1. Click the Choose Themes icon in the Tools bar.

Choose Themes

The **Theme Selection** dialogue box appears. This lists the available themes for the whole spreadsheet and the Styles window lists the custom styles for specific cells.
  1. In the Theme Selection dialogue box, select the theme that you want to apply to the spreadsheet.

  2. Click OK

As soon as you select another theme in the Theme Selection dialogue box, some of the properties of the custom style will be applied to the current spreadsheet. The modifications will be immediately visible in your spreadsheet.