Data in cells can be aligned horizontally and vertically.

To align data horizontally, use one of the commands described in the table below:

Position in cell

Command menu

Toolbar button in the Alignment section

Key combination

Align left

Format > Align > Align Text Left

editor_alignment_left_icon

Ctrl+L

Center

Format > Align > Center Text

editor_alignment_center_icon_gray

Ctrl+E

Align right

Format > Align > Align Text Right

editor_alignment_right_icon

Ctrl+R

Justify

Format > Align > Justify Text

editor_alignment_justify_icon_gray

Ctrl+J

To align data vertically, use one of the commands described in the table below:

Position in cell

Command menu

Toolbar button in the Alignment section

Top align

Format > Align > Align Text To Top

editor_vertical_alignment_top_icon

Middle

Format > Align > Align Text to Middle

editor_vertical_alignment_middle_icon_gray

Bottom align

Format > Align > Align Text To Bottom

editor_vertical_alignment_bottom_icon

If the text in the cell is rotated, the vertical and horizontal alignment is performed according to the position of the text. For example, if you want to align horizontally a text rotated at a 90 degrees angle in a cell, the text will be adjusted relative to the upper and lower boundary of the cell, as these boundaries are located directly to the left and right of the text.
Was the material useful?
Yes
No
Users found this material useful: 0 из 0