Excel is often used when merging cells. Do you need to perform multiple operations if you want to merge cells in multiple places? In fact, it doesn't need to be so troublesome. We can perform batch operations. Let's take a look at the specific operation methods.

How

How

How

How

How

How

How

Finally, remember to click the redundant C column. How about the effect? Climb into the cell and try it

In addition, this operation is not limited to Excel 2010, Excel 2003 and Excel 2007 are also applicable, except that the "Go To" of Excel 2003 is in the menu "Edit Location" Location Conditions.

There are also some Excel shortcuts that are common to all versions, such as Ctrl+G or F5.