Alternative to Merge and Center in Excel — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily
Do you ever get merged cells errors? While merged cells can give your table and worksheet titles a nice appearance, they can cause problems with calculations if they appear within your tables and ranges. There is an alternative that will give you the same look, but without the complications of merged cells.
Just as you would with merged cells, select the title and all the cells that span across the top of the table or range. Then, instead of clicking the Merged Cells button, click the dialog box launcher on the Alignment group. In the Text Alignment section at the top, in the Horizontal: field, choose Center Across Selection.
The result looks just like you had done a Merge and Center, but all the cells remain separate. Your text is technically still in the cell in which it was originally entered. It just appears to be centered.
If your data is a mix of both and you want to apply this solution, select the complete range, click on that dialog box launcher in the Alignment group in the Home tab and clear the Merge cells check box.