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.
If you no longer have a need for a particular comment in a cell, you'll want to get rid of it. Here are a couple of ways ...
Discover MoreSheets includes a nifty, undocumented feature that allows you to enlist Google's help in brainstorming. All you need to ...
Discover MoreConditional formatting is a powerful tool you can use to dynamically adjust the formatting in your worksheet. This tip ...
Discover MoreThere are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Copyright © 2019 Sharon Parq Associates, Inc.
Comments