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 cetner the text inside of your Excel 2010 cells.


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



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. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.