• Excel Video Tutorials

Merge & Wrap in Excel 2010


Advertisements

Merge Cells

MS 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 & Center control on the Ribbon, which is simpler. To merge cells, select the cells that you want to merge and then click the Merge & Center button.

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

Merge Cells from Format 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 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.

Wrap Text

Useful Video Courses


Video

MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani

Video

Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani

Video

Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani

Video

Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning

Video

Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning

Video

Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj

Advertisements