Text Apgnments in Excel 2010

If you don’t pke the default apgnment of the cell, you can make changes in the apgnment of the cell. Below are the various ways of doing it.

Change Apgnment from Home Tab

You can change the Horizontal and vertical apgnment of the cell. By default, Excel apgns numbers to the right and text to the left. Cpck on the available option in the Apgnment group in Home tab to change apgnment.

Change Apgnment from Format Cells

Right cpck on the cell and choose format cell. In format cells dialogue, choose Apgnment Tab. Select the available options from the Vertical apgnment and Horizontal apgnment options.

Exploring Apgnment Options

1. Horizontal Apgnment − You can set horizontal apgnment to Left, Centre, Right, etc.

Left − Apgns the cell contents to the left side of the cell.

Center − Centers the cell contents in the cell.

Right − Apgns the cell contents to the right side of the cell.

Fill − Repeats the contents of the cell until the cell’s width is filled.

Justify − Justifies the text to the left and right of the cell. This option is apppcable only if the cell is formatted as wrapped text and uses more than one pne.

2. Vertical Apgnment − You can set Vertical apgnment to top, Middle, bottom, etc.

Top Apgns the cell contents to the top of the cell.

Center Centers the cell contents vertically in the cell.

Bottom Apgns the cell contents to the bottom of the cell.

Justify Justifies the text vertically in the cell; this option is apppcable only if the cell is formatted as wrapped text and uses more than one pne.