HomePrivacy PolicyFeedbackLink to usSite Map

MS Excel: Center text across multiple cells in Excel 2007

Also learn how to center text across multiple cells in Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.

Question:  I want to center text across multiple cells in Excel 2007 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.


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


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


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