How to Vertically Center Text in an Excel 2010 Cell

A cell in a Microsoft Excel 2010 worksheet can contain a variety of different types of information, and many of the possibilities will result in a taller cell.

If this includes something like a picture, then you may find yourself with one cell in a row that includes a large picture, while the rest of the cells in that row contain only a single line of data.

This disparity between information in cells in the same row can look somewhat odd, but it can be improved by vertically centering the data in other cells in that row.

This is accomplished with the Middle Align feature, which will take data in a selected cell and display it in the vertical middle of the cell. This can be applied to any number of selected cells by following our short tutorial below.

Apply Vertical Centering to Selected Cells in Excel 2010

We will be vertically centering cell data in a single cell in our guide below, but the same method can be applied to any group of selected cells in Excel 2010. It can even be done to an entire spreadsheet, if you have selected all of the cells. This article can show you how to select all of the cells in a spreadsheet if you do not know how.

Step 1: Open your spreadsheet in Excel 2010.

Step 2: Select the cell containing the information that you want to center vertically. As mentioned previously, you can select multiple cells, rows or columns instead of a single cell.

select the cells

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

click the Home tab

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

click the middle align button

Now that you know how to vertically center text in an Excel 2010 cell, you can use this to change the way that content displays when a cell has a large row height value.

Would you like to simultaneously center all of the text in a column horizontally? Read here to find out how to do it in Excel 2010.

Join Our Free Newsletter

Featured guides and deals

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