/text/scalc/guide/format_table.xhp text in cells; formatting spreadsheets;formatting backgrounds;cells and pages borders;cells and pages formatting;spreadsheets numbers; formatting options for selected cells cells; number formats currencies;formats mw transferred 2 entries from shared/01/05020300.xhp and added 2 new entriesmw deleted "defaults;" 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 CommandCtrl key when clicking), and then activating the Format Cells dialog in Format - Cells. 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 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.

Number Formatting Options Backgrounds for Cells