by Allen Wyatt
(last updated March 20, 2014)
When you first enter information into a spreadsheet cell, Sheets aligns that information based on the type of data you are entering. If you are entering text, the information is aligned toward the left of the cell. If you are entering a number, then it is aligned toward the right of the cell. Regardless of the data type, the information in a cell is, by default, aligned toward the bottom of the cell.
To change the alignment of the contents of a cell (or range of cells) there are two tools you need to be familiar with. (See Figure 1.)
Figure 1. Sheets provides two alignment tools on the toolbar.
The left-most alignment tool is Horizontal Align and the one next to it is Vertical Align. With your cells selected you can use either of these tools:
The purpose of gridlines is to make it easy to identify and select cells in a spreadsheet. If you find the gridlines to ...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
Flubaroo is a third-party extension for Sheets that can help make grading classroom papers fast and easy. Here's a quick ...Discover More