Operation Manual

Shrinking text to fit the cell
The font size of the data in a cell can automatically adjust to fit inside cell borders. To do this,
select the Shrink to fit cell size option under Properties in the Format Cells dialog (Figure 117) on
the Alignment page. This dialog is also available by clicking the More Options button in the
Character title bar of the Properties deck on the opened Sidebar.
Formatting numbers
Several different number formats can be applied to cells by using icons on the Formatting toolbar
(highlighted in Figure 119). Select the cell, then click the relevant icon to change the number
format.
Figure 119: Number icons on Formatting toolbar
For more control or to select other number formats, use the Numbers page of the Format Cells
dialog (Figure 108 on page 134):
• Apply any of the data types in the Category list to the data.
• Control the number of decimal places and leading zeros in Options.
• Enter a custom format code.
• The Language setting controls the local settings for the different formats such as the date
format and currency symbol.
Some number formats are available from the Sidebar’s Number Format panel in the Properties
deck. Click the More Options button to open the Format Cells dialog described above.
Figure 120: Number format icons in the
Number Format panel on the Sidebar
Formatting a font
To quickly select a font and format it for use in a cell:
1) Select the cell.
2) Click the small triangle on the right of the Font Name box on the Formatting toolbar
(highlighted in Figure 121) and select a font from the drop-down list.
3) Click on the small triangle on the right of the Font Size on the Formatting toolbar and select
a font size from the drop down list.
Figure 121: Font Name and Size on Formatting toolbar
144 | Getting Started with LibreOffice 5.0