Formatting Bar

The Formatting bar contains basic commands for applying manually formatting.

Styles

Specifies whether to show or hide the Styles window, which is where you can assign and organise Styles.

Icon

Styles

Font Name

Allows you to select a font name from the list or enter a font name directly.

You can enter several fonts, separated by semicolons. LibreOffice uses each named font in succession if the previous fonts are not available.

Icon

Font Name

Font Size

Allows you to choose between different font sizes from the list, or to enter a size manually.

Bold

Makes the selected text bold. If the cursor is in a word, the entire word is made bold. If the selection or word is already bold, the formatting is removed.

Icon

Bold

Italic

Makes the selected text italic. If the cursor is in a word, the entire word is made italic. If the selection or word is already italic, the formatting is removed.

Icon

Italic

Underline

Underlines or removes underlining from the selected text.

Icon

Underline

Font Colour

Click to apply the current font colour to the selected characters. You can also click here, and then drag a selection to change the text colour. Click the arrow next to the icon to open the Font colour toolbar.

Icon

Font Colour

Align Left

Aligns the contents of the cell to the left.

Icon

Align Left

Align Centre Horizontally

Horizontally centres the contents of the cell.

Icon

Align Right

Aligns the contents of the cell to the right.

Icon

Align Right

Justify

Aligns the contents of the cell to the left and to the right cell borders.

Icon

Justified

Number format: Currency

Applies the default currency format to the selected cells.

Icon

Number Format: Currency

Number format: Percent

Applies the percentage format to the selected cells.

Icon

Number Format: Percent

Number format: Default

Applies the default number format to the selected cells.

Icon

Number Format: Standard

Number Format: Add Decimal Place

Adds one decimal place to the numbers in the selected cells.

Icon

Number Format: Add Decimal Place

Number Format: Delete Decimal Place

Removes one decimal place from the numbers in the selected cells.

Icon

Number Format: Delete Decimal Place

Decrease Indent

Click the Decrease Indent icon to reduce the left indent of the current paragraph or cell content and set it to the previous default tab position.

Icon

Decrease Indent

Increase Indent

Click the Increase Indent icon to increase the left indent of the current paragraph or cell content and set it to the next default tab position.

Icon

Increase Indent

Borders

Click the Borders icon to open the Borders toolbar, with which you can modify the border of a sheet area or an object.

Icon

Borders

Background Colour

Click to open a toolbar where you can click a background colour for a paragraph. The colour is applied to the background of the current paragraph or the selected paragraphs.

Icon

Background Colour

Align Top

Aligns the contents of the cell to the upper edge of the cell.

Icon

Align Top

Align Centre Vertically

Vertically centres the contents of the cell.

Icon

Align Centre Vertically

Align Bottom

Aligns the contents of the cell to the lower edge of the cell.

Icon

Align Bottom

Number Format : Date

Applies the date format to the selected cells.

Number Format: Exponential

Applies the exponential format to the selected cells.

Additional icons

If CTL support is enabled, two additional icons are visible.

Left-To-Right

left to right icon

The text is entered from left to right.

Right-To-Left

right to left icon

The text formatted in a complex text layout language is entered from right to left.