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

Formatting Spreadsheets

Formatting Text in a Spreadsheet

  1. Select the text you want to format.

  2. Choose the desired text attributes from the Formatting Bar. You can also choose Format - Cells. The Format Cells dialogue box will appear in which you can choose various text attributes on the Font tab page.

Formatting Numbers in a Spreadsheet

  1. Select the cells containing the numbers you want to format.

  2. To format numbers in the default currency format or as percentages, use the icons on the Formatting Bar. For other formats, choose Format - Cells. You can choose from the preset formats or define your own on the Numbers tab page.

Formatting Borders and Backgrounds for Cells and Pages

  1. You can assign a format to any group of cells by first selecting the cells (for multiple selection, hold down the Ctrl key when clicking), and then activating the Format Cells dialogue box in Format - Cells. In this dialogue box, you can select attributes such as shadows and backgrounds.

  2. To apply formatting attributes to an entire sheet, choose Format - Page. You can define headers and footers, for example, to appear on each printed page.

An image that you have loaded with Format - Page - Background is only visible in print or in the print preview. To display a background image on screen as well, insert the graphic image by choosing Insert - Image - From File and arrange the image behind the cells by choosing Format - Arrange - To Background. Use the Navigator to select the background image.