Merging and unmerging cells in Microsoft Excel is a great way to keep your spreadsheet clean, well-organized, and easy to understand. The most common use is creating a header to identify the content across several columns, but no matter the reason, it can quickly be done in Excel.

在Microsoft Excel中合并和取消合并单元格是保持电子表格整洁，组织良好且易于理解的好方法。 最常见的用法是创建标题以跨几列标识内容，但是无论出于何种原因，都可以在Excel中快速完成。

Note that Excel doesn’t allow you to split a cell the same way that you can in a table in Microsoft Word. You can unmerge cells that you have previously merged.

请注意，Excel不允许您像在Microsoft Word中的表格中一样拆分单元格。 您可以取消合并以前合并的单元格。

合并单元格 (Merging Cells)

Merging cells combines two or more cells into a single cell. To do this, select the cells you want to merge.

合并单元将两个或多个单元合并为一个单元。 为此，选择要合并的单元格。

Next, on the “Home” tab, click the “Merge and Center” button.

接下来，在“主页”选项卡上，单击“合并和居中”按钮。

As the name implies, this will merge the selected cells. Any text in the cells will be centered by default.

顾名思义，这将合并选定的单元格。 默认情况下，单元格中的所有文本都将居中。

As you can see, the A1, B1, and C1 cells have merged into one single cell. There are also other options to choose from. To access these options, click the arrow next to “Merge and Center” and a dropdown menu will appear.

如您所见，A1，B1和C1单元已合并为一个单元。 还有其他选项可供选择。 要访问这些选项，请单击“合并和居中”旁边的箭头，然后会出现一个下拉菜单。

These options are relatively straight-forward. One thing to note is that “Merge Across” merges only the selected cells in a row, but not the cells in a column.

这些选项相对简单。 要注意的一件事是，“合并跨”仅合并一行中选定的单元格，而不合并一列中的单元格。

So what happens if we merge cells that already have content in them? This is something you have to be very careful with. Merging cells with already-existing data only keeps the upper-left value and discards all other values. That means all data except the data in the upper-left cell will be deleted. Microsoft does give you a warning message before merging the cells, though, but do make sure you understand that the data will be lost before continuing.

那么，如果我们合并其中已经有内容的单元格，会发生什么？ 这是您必须非常小心的事情。 合并具有现有数据的单元格仅保留左上角的值，并丢弃所有其他值。 这意味着除左上单元格中的数据外的所有数据都将被删除。 但是，Microsoft确实会在合并单元之前向您发出警告消息，但是请确保在继续之前确保您了解数据将丢失。

合并单元格 (Unmerging Cells)

Unmerging cells splits previously merged cells back into single cells. Doing so is as easy as selecting the merged cells and then clicking the “Merge and Center” button again to toggle the setting off. Similarly, you can click the arrow next to “Merge and Center” to access the drop-down menu and then click “Unmerge Cells.”

未合并的单元格将先前合并的单元格分裂回单个单元格。 这样做就像选择合并的单元格，然后再次单击“合并和居中”按钮以将设置关闭一样容易。 同样，您可以单击“合并和居中”旁边的箭头以访问下拉菜单，然后单击“取消合并单元格”。

If you unmerge a cell that contains data, all of the data is placed in the top-left cell, and all other cells will be empty.

如果取消合并包含数据的单元格，则所有数据都将放置在左上角的单元格中，所有其他单元格将为空。

翻译自: