Formatting Spreadsheets

Formatting Text in a Spreadsheet

Select the text you want to format.
Choose the desired text attributes from the Formatting Bar. You can also choose Format - Cells. The Format Cells dialog will appear in which you can choose various text attributes on the Font tab page.

Formatting Numbers in a Spreadsheet

Select the cells containing the numbers you want to format.
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

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 dialog in Format - Cell. In this dialog, you can select attributes such as shadows and backgrounds.
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 page preview. To display a background image on screen as well, insert the graphic image by choosing Insert - Picture - From File and arrange the image behind the cells by choosing Format - Arrange - To Background. Use the Navigator to select the background image.

Applying Automatic Formatting to a Selected Cell Range

Index

text in cells, formatting

spreadsheets,formatting

backgrounds,cells and pages

borders,cells and pages

formatting,spreadsheets

This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.