Excel irregular Area Merge cell bulk Operations

Although the merged cell is a trouble to the Lord, but because others grow better, so still popular everywhere, such as the next picture in a column, look at the less pleasing, if the change to D column, it is much more popular. However, each area is not the same size, one by one to merge 10 Eight is OK, Chi is too sorry to the mouse classmate, how to batch operation?

Finally remember to cut the extra C column. What's the effect? Crawl into a cell and try it. ^_^

In addition, this operation is not limited to version 2010, Version 2003 and 2007 are also applicable, just 2003 version of "Go" in the menu "edit" positioning criteria.

There are also several versions of the common shortcut keys can be used, such as the positioning of the shortcut keys Ctrl+g or F5.