In Excel alignment is important to be able to easily read data. Learn to format text and tables in various ways in Excel.
We've previously seen how to align text or numbers using the left-align, center, and right-align buttons in the Standard toolbar. You can also define alignment in the Alignment tab of the Format Cells dialog box.
The Horizontal section features a drop-down menu that contains the same left, center, and right alignment options in the picture above and several more:
"Fills" the cell with the current contents by repeating the contents for the width of the cell.
If the text is larger than the cell width, Justify wraps the text in the cell and adjusts the spacing within each line so all lines are as wide as the cell.
Contents of the cell farthest to the left are centered across the selection of cells. This function is similar to Merge and Center, except the cells are not merged.