From LibreOffice Help
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 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.|