Excel Tips Tutorial: Horizontal Text Alignment in Excel (General, Left, Center, Right, Fill, Justify, Center across Selection and Distributed)
In Excel you have many different options to align your text that are not available in the ribbon. The Excel ribbon offers you the option to align text left, center and right but in order to apply other alignment options you are going to have to use the Format Cells dialog box. To access the Format Cells dialog box simply press CTRL+1 and the Format Cells dialog box will appear. Then click on the alignment tab and you will see the Horizontal Alignment drop-down menu in the Text Alignment group. Select the alignment option you prefer and press OK.
- General: Aligns Numbers to the right, text to the left and errors to the center.
- Left (Indent): Aligns content to the left of the cell.
- Center: Centers the content within the cell.
- Right: Aligns the cell content to the right of the cell.
- Fill: Repeat the cell content until the entire width of the cell is filled.
- Justify: This justifies the text to the left and the right.
- Center across Selection: Centers the text over selected columns.
- Distributed: This alignment options distributes the content evenly in the selected column.