How to Vertically Center Cell Data in Google Sheets


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

select the cells to center vertically

 

 

Step 3: Click the Vertical align button in the gray toolbar above the spreadsheet.

click the vertical alignment button

 

 

Step 4: Select the middle option to vertically align the selected cell data.

how to center vertically in google sheets

 

 

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.

birthday t-shirts for boys
vintage t rex t-shirt

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