This document describes the process of centering text across a selection in Excel 2016. This is a valuable alternative to merging cells in Excel to avoid data manipulation issues.
Merging cells in Excel can be useful in some cases, but can be largely problematic when each individual cell in the group needs to be accessed later on.
To avoid this issue, use the Center Across Selection formatting option to create identical formatting to merged cells and avoid data issues.
For information on merging cells in Excel, see Excel - How to Merge Cells
To center cells without merging:
Select the grouping of cells that you would like to merge.
Right click on the selected area and click Format Cells.
Click the Alignment tab at the top of the pop-up menu.
In the Alignment tab, open the Horizontal dropdown and select Center Across Selection.
Click OK to finalize and the cells will appear merged.