If you don’t like the default alignment of the cell, you can make changes in the alignment of the cell. Below are the various ways of doing it.
Change Alignment From Home Tab
You can change the Horizontal and vertical alignment of the cell. By default, Excel aligns numbers to the right and text to the left. Click on the available option in the Alignment group in Home tab to change alignment.
Change Alignment From Format Cells
Right click on the cell and choose format cell. In format cells dialogue, choose Alignment Tab. Select the available options from the Vertical alignment and Horizontal alignment options.
Exploring Alignment Options
1. Horizontal Alignment − You can set horizontal alignment to Left, Centre, Right, etc.
Left − Aligns the cell contents to the left side of the cell.
Center − Centers the cell contents in the cell.
Right − Aligns 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 applicable only if the cell is formatted as wrapped text and uses more than one line.
2. Vertical Alignment − You can set Vertical alignment to top, Middle, bottom, etc.
Justify Justifies the text vertically in the cell; this option is applicable only if the cell is formatted as wrapped text and uses more than one line.
Merge And Wrap In Excel 2010
Merge Cells
Microsoft Excel enables you to merge two or more cells. When you merge cells, you don’t combine the contents of the cells. Rather, you combine a group of cells into a single cell that occupies the same space.
You can merge cells by various ways as mentioned below.
Choose Merge and Center control on the Ribbon, which is simpler. To merge cells, select the cells that you want to merge and then click the Merge and Center button.
Choose Alignment tab of the Format Cells dialogue box to merge the cells.
Additional Options
The Home » Alignment group » Merge and Center control contains a drop-down list with these additional options:
Merge Across − When a multi-row range is selected, this command creates multiple merged cells — one for each row.
Merge Cells − Merges the selected cells without applying the Center attribute.
Unmerge Cells − Unmerges the selected cells.
Wrap Text and Shrink to Fit
If the text is too wide to fit the column width but don’t want that text to spill over into adjacent cells, you can use either the Wrap Text option or the Shrink to Fit option to accommodate that text.
Change Alignment From Home Tab
You can change the Horizontal and vertical alignment of the cell. By default, Excel aligns numbers to the right and text to the left. Click on the available option in the Alignment group in Home tab to change alignment.
Right click on the cell and choose format cell. In format cells dialogue, choose Alignment Tab. Select the available options from the Vertical alignment and Horizontal alignment options.
1. Horizontal Alignment − You can set horizontal alignment to Left, Centre, Right, etc.
Left − Aligns the cell contents to the left side of the cell.
Center − Centers the cell contents in the cell.
Right − Aligns 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 applicable only if the cell is formatted as wrapped text and uses more than one line.
2. Vertical Alignment − You can set Vertical alignment to top, Middle, bottom, etc.
- Top Aligns the cell contents to the top of the cell.
Center Centers the cell contents vertically in the cell.
Bottom Aligns the cell contents to the bottom of the cell.
Justify Justifies the text vertically in the cell; this option is applicable only if the cell is formatted as wrapped text and uses more than one line.
Merge Cells
Microsoft Excel enables you to merge two or more cells. When you merge cells, you don’t combine the contents of the cells. Rather, you combine a group of cells into a single cell that occupies the same space.
You can merge cells by various ways as mentioned below.
Choose Merge and Center control on the Ribbon, which is simpler. To merge cells, select the cells that you want to merge and then click the Merge and Center button.
The Home » Alignment group » Merge and Center control contains a drop-down list with these additional options:
Merge Across − When a multi-row range is selected, this command creates multiple merged cells — one for each row.
Merge Cells − Merges the selected cells without applying the Center attribute.
Unmerge Cells − Unmerges the selected cells.
Wrap Text and Shrink to Fit
If the text is too wide to fit the column width but don’t want that text to spill over into adjacent cells, you can use either the Wrap Text option or the Shrink to Fit option to accommodate that text.
0 Comments