Tom’s Tutorials For Excel: Using Center Across Selection Instead of Merging Cells
When you want to center a cell’s value across several columns, please avoid the Merge Cells method. Merged cells cause more programming and design headaches than any single feature in Excel.
There is a better way, by formatting the cells using “Center Across Selection”, shown by example in the following Before and After set of pictures.
To accomplish this, simply select the cells where you want the header value to be centered across. In this example, the header value is in cell A1, and range A1:D1 has been selected. Next, right-click the selected range, and from the popup menu, click on Format Cells.
In the Format Cells dialog box, click onto the Alignment tab.
Click the drop down arrow for the Horizontal field in the Text Alignment section.
Select “Center Across Selection”, and click OK.