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.
Step 3: Click the Home tab at the top of the window.
Step 4: Click the Middle Align button in the Alignment section of the ribbon at the top of the window.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.