Learning the more scientific merge center from Excel 2007
As we all know, Excel has a "merge center" function - you can merge multiple cells into one cell. If we want to merge more than one cell of each line into a single cell, you can operate it by only one line in previous versions.
However, you can complete this operation by one-time in Excel 2007. Selected multiple range of cells which need to merge, expand the "Start" menu tab, click the "Merge and Center" button on the right of the drop-down button, and then elect the "cross merge " option in the pop-up drop-down list.
For some users this feature is really very useful and wonderful, especially for the people who always need to use Excel to work. So, if your work need to use this feature frequently, maybe this is a very good choice.