- Select the range where you want to merge and center the title.
- In this example I want to have the title go across the range. I select this range
- Select the home tab and then under the alignment group click on the
- Merge Cells Command button.
- The merge cells button combines the selected cells into one cell.
How to join two cells in Excel
So, is there a way to split cells up? Like if someone puts the first and last name in one cell and you want it split into separate cells?