
Using the alignment options makes it easier to read the text and data in a spreadsheet.
Change Horizontal Alignment
- Select a cell or cell range.
- Click the Horizontal align button
- Select an alignment option.
Change Vertical Alignment
You can also change a cell's vertical alignment.
- Select a cell or cell range.
- Click the Vertical align button.
- Select an alignment option.
Cell Alignment Buttons | Description |
---|---|
Left/Center/Right Align
![]() ![]() ![]() |
Align cell contents to the left side, center, or right side of the cell using these three buttons. |
Text rotation![]() |
Align cell contents diagonally or vertically. |
Text Wrapping![]() |
Make all cell contents visible by displaying them on multiple lines within the cell (this increases the row's height). |
Merge cells![]() |
Select from a few options for merging cells together. |
Wrap Text
You can also control how text wraps if the cell isn't wide enough to display it all.
- Select a cell or cell range.
- Click the Text wrapping button.
There are three ways that text can wrap in a cell:
- The first is for the text to overflow into the next cell.
- You can also choose to wrap text into a second line.
- Or, to just clip the text off at the cell border.
- Select a text wrapping option.
The text in the cell wraps around to a new line.
Merge Cells
You can also merge several cells together to display text across multiple columns or rows.
The selected cells and merged into a single cell.
Unmerge Cells
If you need to separate the cells again, unmerging them works the same way.
- Select the merged cell.
When the merged cell is selected, the Merge Cells button on the toolbar will be active.
- Click the Merge cells button.
The selected cells are split.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.