Excel 简明教程

Merge & Wrap in Excel 2010

Merge Cells

MS Excel 使你能够合并两个或更多单元格。合并单元格时，并不合并单元格的内容。而是将一组单元格合并为一个占据相同空间的单元格。

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.

  1. 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

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

merge cells format cells

Additional Options

Home » Alignment group » Merge & Center control 包含一个带以下附加选项的下拉列表 −

The Home » Alignment group » Merge & Center control contains a drop-down list with these additional options −

  1. Merge Across − When a multi-row range is selected, this command creates multiple merged cells — one for each row.

  2. Merge Cells − Merges the selected cells without applying the Center attribute.

  3. 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.

text wrap