Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Alignment

Sets the alignment options for the content of the current cell, or the selected cells.

To access this command...

Choose Format - Title - Main Title - Alignment tab.Choose Format - Cells - Alignment tab.

Open context menu of a column header in a database table - choose Column Format - Alignment tab.

Horizontal

Select the horizontal alignment option that you want to apply to the cell content.

Default

Aligns numbers to the right, and text to the left.

If the Default option is selected, numbers will be aligned to the right and text will be left-justified.

Left

Aligns the contents of the cell to the left.

Icon on the Formatting Bar:

Align Left

Aligns the contents of the cell to the right.

Icon on the Formatting Bar:

Align Right

Centre

Horizontally centres the contents of the cell.

Icon on the Formatting Bar:

Align Centre HorizontallyCentred

Justified

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

Icon on the Formatting Bar:

Justified

Filled

Repeats the cell content (number and text) until the visible area of the cell is filled. This feature does not work on text that contains line breaks.

Distributed

Aligns contents evenly across the whole cell. Unlike Justified, it justifies the very last line of text, too.

Indent

Indents from the left edge of the cell by the amount that you enter.

Vertical

Select the vertical alignment option that you want to apply to the cell content.

Default

Aligns the cell content to the bottom of the cell.

Top

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

Icon on the Formatting Bar:

Align Top

Bottom

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

Icon on the Formatting Bar:

Align Bottom

Middle

Vertically centres the contents of the cell.

Icon on the Formatting Bar:

Align Centre Vertically

Justified

Aligns the contents of the cell to the top and to the bottom cell borders.

Distributed

Same as Justified, unless the text orientation is vertical. Then it behaves similarly, than horizontal Distributed setting, i.e. the very last line is justified, too.

Text orientation

Sets the text orientation of the cell content.

Click in the dial to set the text orientation.

Degrees

Enter the rotation angle from 0 to 360 for the text in the selected cell(s).

Reference edge

Specify the cell edge from which to write the rotated text.

  1. Text Extension From Lower Cell Border: Writes the rotated text from the bottom cell edge outwards.

  2. Text Extension From Upper Cell Border: Writes the rotated text from the top cell edge outwards.

  3. Text Extension Inside Cells: Writes the rotated text only within the cell.

Vertically stacked

Aligns text vertically.

These commands can only be accessed after you enable support for Asian languages in Tools - Options - Language Settings - Languages.

Asian layout mode

This check box is only available if Asian language support is enabled and the text direction is set to vertical. Aligns Asian characters one below the other in the selected cell(s). If the cell contains more than one line of text, the lines are converted to text columns that are arranged from right to left. Western characters in the converted text are rotated 90 degrees to the right. Asian characters are not rotated.

Properties

Determine the text flow in a cell.

Wrap text automatically

Wraps text onto another line at the cell border. The number of lines depends on the width of the cell. To enter a manual line break, press Ctrl+Enter in the cell.

Inserting Line Breaks in Cells

Hyphenation active

Enables word hyphenation for text wrapping to the next line.

Shrink to fit cell size

Reduces the apparent size of the font so that the contents of the cell fit into the current cell width. You cannot apply this command to a cell that contains line breaks.