Formatting Bar

The Formatting bar contains basic commands for applying manually formatting.

StylesStylesStyles

Specifies whether to show or hide the Styles window, which is where you can assign and organise 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. Office uses each named font in succession if the previous fonts are not available.

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.

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.

Underline

Underlines or removes underlining from the selected text.

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.

Align Left

Aligns the contents of the cell to the left.

Align Centre Horizontally

Horizontally centres the contents of the cell.

Align Right

Aligns the contents of the cell to the right.

Justify

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

Number format: Currency

Applies the default currency format to the selected cells.

Number format: Percent

Applies the percentage format to the selected cells.

Number format: Default

Applies the default number format to the selected cells.

Number Format: Add Decimal Place

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

Number Format: Delete Decimal Place

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

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.

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.

Borders

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

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.

Align Top

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

Align Centre Vertically

Vertically centres the contents of the cell.

Align Bottom

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

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

Right-To-Left