The default vertical alignment for data in Google Sheets cells will place that data on the bottom of the cell. But the structure of your spreadsheet might dictate that the data be placed in the center of the cell, so you may find yourself looking for a way to vertically center data in the cells of your spreadsheet.
Fortunately this is an option that is available in Google sheets, so you will be able to change the vertical alignment of your cells. You have the option to align it at the top, middle or bottom. Our guide below will show you where to find this setting.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
How to Put Data in the Vertical Middle of the Cell in Google Sheets
The steps in this article were performed in Google Chrome, but should also work in other Web browsers as well. When you complete this tutorial you will have a cell (or cells) of data where the cell content is centered vertically inside the cell.
Step 1: Go to your Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet containing the cell that you would like to center vertically.
Step 2: Select the cell(s) that you want to center.
Step 3: Click the Vertical align button in the gray toolbar above the spreadsheet.
Step 4: Select the middle option to vertically align the selected cell data.
Note that you can also change the vertical alignment of a cell by clicking the Format tab at the top of the window, then Align, then select the desired vertical alignment.
Does your spreadsheet have cell shading that you would either like to remove or change? Learn how to change cell shading, or fill color, in Google Sheets.
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.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.