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 |
Format > Alignment > Left |
Ctrl+Shift+L ( |
|
Center |
|
Format > Alignment > Center |
Ctrl+Shift+E ( |
Align right |
Format > Alignment > Right |
Ctrl+Shift+R ( |
|
Justify |
Format > Alignment > Justify |
Ctrl+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 |
Format > Alignment > Top |
|
Middle |
Format > Alignment > Middle |
|
Bottom align |
Format > Alignment > Bottom |