Changing Fonts and Type Sizes


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.

Note

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:

  • Arial

  • Courier New

  • Georgia

  • Trebuchet

  • Verdana

Note

The Normal font on the Font Family list applies the Arial font.


To change fonts or type size, follow these steps:

1.

Select the Format tab.

2.

Select a cell or range of cells.

3.

Click the Font Family or Font Size buttons, then select the font or size from the pull-down list. (Figure 25 shows the Font Family options; Figure 26 shows the Font Size options.)

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:

  • Horizontal: Left, centered, and right (shown in Figure 27)

    Figure 27. Left, centered, and right horizontal alignments.

  • Vertical: Top, middle, and bottom (shown in Figure 28)

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:

1.

Select the Format tab.

2.

Select a cell or range of cells.

3.

Click the Align button, then select a horizontal or vertical alignment.

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.

Table 5. Google Spreadsheets Number Formats

Number Format

Number Typed: 5000

Number Typed: 5

Number Typed: -5

Number Typed: .5

Plain Text

5000

5

-5

0.5

Normal

5000

5

-5

0.5

Rounded

5,000

5

-5

0

2 Decimals

5,000.00

5.00

-5.00

0.50

Financial Rounded

5,000

5

(5)

0

Financial

5,000.00

5.00

(5.00)

0.50

Dollar

$5,000

$5

-$5

$0

Dollar and Cents

$5,000.00

$5.00

-$5.00

$0.50


Table 6. Google Spreadsheets Percent Formats

Number Format

Number Typed: 5

Number Typed: .5

Number Typed: .005

Number Typed: -.5

Percent Rounded

500%

50%

0%

-50%

Percent

500.00%

50.00%

0.50%

-50.00%


Table 7. Google Spreadsheets Date and Time Formats.

Number Format

Example

Date (1)

2/14/2006

Date (2)

14-Feb-2006

Time

2:45:30

Date Time

2/14/2006 2:45:30


Note

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:

1.

Select the Format tab.

2.

Select the cell or range.

3.

Click the Choose Format button.

4.

Choose the number format from the list, as shown in Figure 29.

Figure 29. Choosing a number format.