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.
The formula bar is where you can see exactly what is stored in a spreadsheet cell. If you would rather hide the formula bar, ...Discover More
As you are developing a spreadsheet, you'll often have the need to insert additional rows into your data. Sheets makes this ...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