Please support us!

Pgk5a‖

NBiTX‖Cell Alignment

BECu2‖Sets the alignment options for the contents of the current cell, or the selected cells.

To access this command...

ebLJB‖From the menu bar:

EXsSt‖Choose Format - Cell - Alignment tab.

t8dFS‖From the context menu:

wRUK5‖With cursor on a cell, choose Format Cells.

qBbLh‖From the tabbed interface:

HAPwN‖Home tab, Alignment group.

sXy2C‖From toolbars:

tTfvv‖From the sidebar:

cm79X‖Open the Properties pane, then Alignment deck.

GBzN2‖From the keyboard:

dqqYE‖Ctrl + 1, then Alignment


AdrCE‖Text Alignment

HEjki‖Horizontal

VAcyD‖Select the horizontal alignment option that you want to apply to the cell contents.

kz67h‖Default

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

Note Icon

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


QB4XW‖Left

7pF5w‖Aligns the contents of the cell to the left.

XFtDx‖Icon Align Start

ytUds‖

isB6Y‖Right

FU9mV‖Aligns the contents of the cell to the right.

EDVnB‖Icon Align End

Zf2DM‖

vDDtC‖Center

NqnXg‖Horizontally centers the contents of the cell.

AqNAB‖Icon Centered

CQD3j‖

BxW8o‖Justified

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

DA7g8‖Icon Justified

YBkwj‖Justified

hCmDa‖Filled

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

FrPJj‖Distributed

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

8PBsM‖Indent

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

bEmmh‖Vertical

HtsDS‖Select the vertical alignment option that you want to apply to the cell contents.

9AGtA‖Default

HKLFy‖Aligns the cell contents to the bottom of the cell.

gPExx‖Top

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

xbEGb‖Bottom

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

Wpxgj‖Icon Align Bottom

Ef3xo‖Align Bottom

cGGgE‖Middle

ESZgN‖Vertically centers the contents of the cell.

FnHvn‖Icon Align Center Vertically

azeZ6‖Align Center Vertically

FRrpV‖Justified

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

QB2k3‖Distributed

LBGXC‖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.

4uehz‖Text orientation

pp7Ac‖Sets the text orientation of the cell contents.

VuN3E‖Vertically stacked

xC4DT‖Aligns text vertically.

DQj68‖These commands can only be accessed after you enable support for Asian languages in - Languages and Locales - General.

G3Qfo‖Asian layout mode

b7bkd‖This checkbox 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.

HH2G8‖Degrees

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

7fB8W‖Click in the dial to set the text orientation.

vvSoG‖Reference edge

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

dTDU5‖Text Extension From Lower Cell Border

gKhAs‖Writes the rotated text from the bottom cell edge outwards.

JDzRp‖Icon Text Extension From Lower Cell Border

CGynz‖Text Extension From Lower Cell Border

98FCN‖Text Extension From Upper Cell Border

YMQfa‖Writes the rotated text from the top cell edge outwards.

8USdY‖Icon Text Extension From Upper Cell Border

jZYut‖Text Extension From Upper Cell Border

3tAW8‖Text Extension Inside Cells

2nHm9‖Writes the rotated text only within the cell.

6vybj‖Icon Text Extension From Inside Cell Border

Ahy8n‖Text Extension From Inside Cell Border

UCLFD‖Properties

YUD9z‖Determine the text flow in a cell.

rCBJY‖Wrap text automatically

j4mvG‖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 +Enter in the cell.

Inserting Line Breaks in Cells

XwhVq‖Hyphenation active

B9uCb‖Enables word hyphenation for text wrapping to the next line.

NSr2E‖Shrink to fit cell size

zuD6E‖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.