How to Center Text in a Column in Excel 2010

Information in adjacent cells in a spreadsheet can become difficult to read if there isn’t a lot of white space between each cell.

One way to combat this problem, however, is by centering text inside of a cell. This will create an equal amount of white space to the left and right of the data in the cell, thereby providing additional padding from the information in surrounding cells.

Follow the steps below to center the text inside of your Excel 2010 cells.

Microsoft Word has a lot of ways to align text as well. Our how to center text in Word article can show you a few of those options.

Centering Text in an Excel 2010 Cell

The directions below are meant to center text inside of a cell horizontally so that there is an equal amount of space to the left and the right of your text.

You can follow a similar process to center your text vertically, however, by clicking the Middle Align button directly above the Center button that we will direct you to below.

Step 1: Open your spreadsheet in Microsoft Excel 2010.

Step 2: Highlight the cells containing the data that you want to center. You can select an entire row or column by clicking the column letter at the top of the spreadsheet or the row number at the left side of the spreadsheet.

select the cells that you want to center

Step 3: Click the Home tab at the top of the window.

click the home tab at the top of the window

Step 4: Click the Center button in the Alignment section of the ribbon at the top of the window.

click the center button in the alignment section of the ribbon

Now that you know how to center text in a column in Excel 2010, you can use this technique whenever you want your cell data to appear in the middle of the column instead of being aligned to one side of it.

Did you know that you can print empty cells in Microsoft Excel if you need a chart that you can write in? Click here to learn how.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy