To center text across multiple horizontal cells in Excel, a solution could be to merge the cells together and then center the text. However, this often makes it harder later on to copy and paste the cells to another Excel sheet.
Instead, we’ll go to alignment settings to center text across cells. First, select the area in which you want the text to be centred in. Then open the alignment settings (it’s in the Home menu). The new prompt should have the alignment tab open. From this window, from the drop down menu select Center Across Selection for the horizontal text alignment.
You should now have separate cells (no merged ones) and the text should be centred between these cells. Read more about Excel tips and tricks on my blog.