Formatting Spreadsheets Using Themes

Getting Started with OpenOffice 4

Chapter 4: Getting Started with Calc

< Previous Section

Next Section >

• What is Calc
• Parts of the main Calc window
• Open and Save CSV files
• Navigating within spreadsheets
  • Going to a particular cell
  • Moving from cell to cell
  • Moving from sheet to sheet
• Selecting items in a sheet or a spreadsheet
  • Selecting Cells
  • Selecting Columns and Rows
  • Selecting Sheets
• Working with Columns and Rows
• Working with Sheets
• Viewing Calc
• Entering data using the keyboard
• Speeding up data entry
• Validating cell contents
• Editing data
• Formatting data
• Auto-formatting cells and sheets
• Formatting spreadsheets using themes
• Using conditional formatting
• Hiding and showing data
• Sorting records
• Using formulas and functions
• Analyzing data
• Printing from Calc
  • Using Print Ranges
  • Selecting the Page Order, Details, and Scale
  • Page Breaks
  • Headers and Footers

< Previous Page

Next Page >

Formatting Spreadsheets Using Themes

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 can not be modified. However, you can modify their styles after you apply them to a spreadsheet.

To apply a theme to a spreadsheet:

1. Click the Choose Themes icon in the Tools toolbar. If this toolbar is not visible, you can show it using View → Toolbars → Tools.
2. The Theme Selection dialog appears. This dialog lists the available themes for the whole spreadsheet.

Figure 98: Tools toolbar with the Choose Themes icon highlighted

3. In the Theme Selection dialog, select the theme that you want to apply to the spreadsheet. As soon as you select a theme, some properties of the custom styles are applied to the open spreadsheet and are immediately visible.
4. Click  OK . If you wish, you can now go to the Styles and Formatting window to modify specific styles. These modifications do not change the theme; they only change the appearance of this specific spreadsheet document.