MS Excel - Merge & Wrap and MS Excel - Apply Formatting

Post By: Hanan Mannan
Contact Number: Pak (+92)-321-59-95-634
-------------------------------------------------------

MS Excel - Merge & Wrap

Merge Cells

MS Excel enables you to merge two or more cells. When you merge cells, you don’t combine the contents of 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 below

• Choose Merge & Center control on the Ribbon is simpler.To merge cells, select the cells that you want to merge and then click the Merge & Center button.

• Choose Alignment tab of the Format Cells dialogue box to merge cells

Additional Options

The Home » Alignment group » Merge & 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 you have text 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.

MS Excel - Apply Formatting

Formatting Cells

In MS Excel you can apply formatting to the cell or range of cells by Right Click» Format cells»Select the tab. Various tabs are available as below

Alternative to placing Background

• Number: You can Set the Format of cell depending on cell content. Find tutorial on this at MS Excel - Setting Cell Type
• Alignment:You can set alignment of text on this tab.Find tutorial on this at MS Excel - Text Alignments
• Font:You can set Font of text on this tab.Find tutorial on this at MS Excel - Setting Fonts
• Border:You can set border of cell with this tab.Find tutorial on this at MS Excel - Borders and Shades
• Fill:You can set fill of cell with this tab.Find tutorial on this at MS Excel - Borders and Shades
• Protection:You can set cell protection option with this tab.