How can we help you?

Data in cells can be aligned horizontally and vertically.

To align data horizontally, select the cell or a cell range and use one of the commands described in the table below:

Position in cell

Command menu

Toolbar button

Key combination

Align left

editor_alignment_left_icon

Format Alignment Left

Ctrl+Shift+L

(command_transparent Cmd+shift_transparent Shift+L)

Center

icon_align_center_gray

Format Alignment Center

Ctrl+Shift+E

(command_transparent Cmd+shift_transparent Shift+E)

Align right

editor_alignment_right_icon

Format Alignment Right

Ctrl+Shift+R

(command_transparent Cmd+shift_transparent Shift+R)

Justify

icon_align_on_width_gray

Format Alignment Justify

Ctrl+Shift+J

(command_transparent Cmd+shift_transparent Shift+J)

 

To align data vertically, the cell or a cell range and use one of the commands described in the table below:

Position in cell

Command menu

Toolbar button

Top align

editor_vertical_alignment_top_icon

Format Alignment Top

Middle

editor_vertical_alignment_middle_icon

Format Alignment Middle

Bottom align

editor_vertical_alignment_bottom_icon

Format Alignment Bottom

Was this helpful?
Yes
No
Previous
Highlight color
Next
Rotate text