Excel: Center text across multiple cells without merging

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.

Center across selection in Excel

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.


Author Bio

Thank you for your interest in my blog! On this miniblog, I write mostly short (technical) blog posts that might interest other people. Read more about me or feel free to contact me.


Leave a Reply

Your email address will not be published. Required fields are marked *