Skip to content

Center Text Across Cells in Excel

In this article, I will show you two ways you can center text across several cells in Excel.

Method 1 – Merge and Center

The first way you can center text across cells is to merge and center those cells.

Take a look at the example below.

Here, I have some sales data. I want to center the title “Sales Data” across cells B2:D2.

To do this, select the range B2:D2 and click the Merge and Center button in the Excel Ribbon.

This will merge the range of cells into a single cell and center the text within that cell, giving you the desired result.

Method 2 – Center Across Selection

Although method one gets the job done, sometimes you want to avoid merging cells. The good news is that you can still center the text across several cells without merging them together.

To do this, select all the cells you want the text centered across. Next, right-click and Format Cells.

Under the Alignment tab, change the horizontal alignment to Center Across Selection.

Once you hit Ok, the text becomes centered across the cells you selected.

And that is how you can center text across cells in Microsoft Excel.

This Post Has One Comment

  1. I’ve been wondering about this! I’ve seen people center across cells without merging and I never knew how! Now I can’t wait to start using this!

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top