When centering headings on an Excel worksheet, most of us use a feature called Merge and Center. Merging and Centering cells in Excel is easy. Just select the cells that you want to merge and click the Merge and Center button in the Alignment group on the Home tab (in Excel 2007, 2010, or 2013).
However, have you ever wanted to merge the cells in several rows, but not wanted to merge all of those cells into one gigantic cell? Did you select the cells in the first row, merge them, move on to the second row and so on? This method works; but fortunately, there is a much simpler way to go about it. The answer is a seldom-used feature called Merge Across.
If you click the down arrow to the right of the Merge and Center command, you will see a command called Merge Across. To use this feature, select all of the cells that you want to merge across but not down. Click the arrow to the right of Merge and Center and select Merge Across. Your cells will be nicely merged across, but each row will still be separate from those above and below them. If you wish to also center the data in the merged cells, simply click the Center button in the Alignment group on the Home tab.
You may have wondered what would happen if you clicked the Merge Across command. Now you know!
For more information on the Business Office Systems and Support department, contact Becky Jones, Associate Dean, firstname.lastname@example.org 972-238-6215.