totn Excel 2013 Basics

MS Excel 2013: Center text across multiple cells

This Excel tutorial explains how to center text across multiple cells in Excel 2013 (with screenshots and step-by-step instructions).

Question: I want to center text across multiple cells in Microsoft Excel 2013 but I don't want to have to merge the cells. How can I do this?

Answer: Select the cells that you wish to center the text across.

TIP: The text that you are trying to center must be in the left most cell (first cell) of the selected range.

Microsoft Excel

Right-click and then select "Format Cells" from the popup menu.

Microsoft Excel

When the Format Cells window appears, select the Alignment tab. Click on "Center Across Selection" in the drop-down box called Horizontal.

Microsoft Excel

Now when you return to your spreadsheet, you should see the text centered across the cells that you selected.

Microsoft Excel