by Allen Wyatt
(last updated February 20, 2014)
When you first enter information into a spreadsheet cell, it is vertically aligned near the bottom of the cell. If you adjust the height of the row in which the cell is located, this may not give the exact "look" that you want for the cell. Fortunately, Sheets allows you to modify where the cell contents appear vertically within the cell.
To adjust vertical alignment, select the cell (or cells) you want to change. Then click the Vertical Align tool on the toolbar. You'll see three options: Top, Middle, and Bottom. (See Figure 1.)
Figure 1. Vertically aligning a cell.
Click the option you want and the spacing is applied to the selected cells.
What day of the week is that date? Sheets can let you know by using the TEXT function to return a weekday name for a ...Discover More
Named ranges can be a great boon in creating easily understandable formulas. Here's what they are an how to define them.Discover More
Adding borders to a cell (or range of cells) is a common way to draw attention to the cell contents. Sheets provides a ...Discover More