Step 1: Go to your Google Drive at and open the spreadsheet containing the cell that you would like to center vertically. When you complete this tutorial you will have a cell (or cells) of data where the cell content is centered vertically inside the cell. The steps in this article were performed in Google Chrome, but should also work in other Web browsers as well. How to Put Data in the Vertical Middle of the Cell in Google Sheets How to change row height in Google Sheets.Our guide below will show you where to find this setting. You have the option to align it at the top, middle or bottom. 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.įortunately this is an option that is available in Google sheets, so you will be able to change the vertical alignment of your cells. The default vertical alignment for data in Google Sheets cells will place that data on the bottom of the cell.