Changing Fonts and Type Sizes
To enhance the appearance of your spreadsheet you can employ different fonts and type sizes for various parts of your document. The method to change fonts and type sizes is identical to the method of applying formatting attributes; select the cell or range of cells, and then click the appropriate button.
As with the way Google Spreadsheets handles text formatting, you can change fonts or type sizes only for an entire cell or range of cells, not for text within a cell.
When it comes to type size, you can choose a range from 6 point to 36 point text. As to fonts, you can choose from the following font families:
The Normal font on the Font Family list applies the Arial font.
To change fonts or type size, follow these steps:
Figure 25. Choosing a new font family for your text.
Figure 26. Choosing a new font size for your text.
Aligning Information in a Cell
Another way to enhance the look of your worksheet is to make sure that data is aligned properly. There are three horizontal and three vertical alignments possible within Google Spreadsheets:
Figure 28. Top, middle, and bottom vertical alignments.
You can choose both a horizontal and a vertical alignment for any cell or range of cells in your spreadsheet. Follow these steps:
If you want to choose both a horizontal and a vertical alignment, you'll have to work through these steps twiceonce for the horizontal alignment, and a second time for the vertical alignment.
Changing Number Formats
There are numerous ways to express a number. A number can be expressed as a whole number, as a percent, as a fraction, as currency, as a date, and even exponentially. Google Spreadsheets employs a wide variety of number formats that you can apply to your data.
Table 5 details the number formats available in Google Spreadsheets; Table 6 details the percent formats; Table 7 details the date and time formats. Examples are included for each.
The difference between the plain text and normal formats is in the alignment. The plain text format is left aligned; the normal format, as with all the other number formats, is right aligned.
Google Spreadsheets applies the Normal number format by default when you enter numbers into your worksheet. You can, however, apply any number format to any particular cell. To apply a different number format, follow these steps:
Figure 29. Choosing a number format.