- 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.