Microsoft Office Tutorials and References
In Depth Information
font can be displayed using one of the following font styles : regular, italic , bold , or bold italic .
Fonts can also be displayed with special effects, such as strikeout, underline , and color.
Fonts can also be rendered in different sizes. Font sizes are measured using points. A
point is a unit of measurement used in printing and is equal to approximately 1/72 of an
inch. By default, Excel displays characters using a 10-point Arial font in a regular style. To
change the font used in a selected cell, you either click the appropriate buttons on the
Formatting toolbar or select options in the Format Cells dialog box.
In the logo that the company uses on all its correspondence and advertising materials,
the name “NewGeneration Monitors” appears in a large Times New Roman font, which is
a serif font. Characters that are designed as serif fonts have small lines stemming from and
at an angle to the upper and lower ends of the character. Sans serif fonts do not include the
small lines. A serif font is considered easier to read than a sans serif font. Joan wants the
title in cell A1 to reflect this company-wide format, so you will format the title accordingly.
To change the font and font size of the title:
1. Click cell A1 to make it the active cell.
2. Click the Font list arrow on the Formatting toolbar, scroll down the list
of available fonts, and then click Times New Roman .
Trouble? If you do not have the Times New Roman font installed on your computer,
choose a different Times Roman font or choose MS Serif or another serif font in the list.
3. Click the Font Size list arrow on the Formatting toolbar, and then click 18 . Figure 3-7
shows the revised format for the title in cell A1.
Changing the font and font size
Joan wants the column titles of both tables displayed in bold font and the word “Total”
in both tables displayed in italics. To make these modifications, you will again use the
To apply the bold and italic styles:
1. Select the nonadjacent range A6:E6;A22:H22 .
2. Click the Bold button on the Formatting toolbar. The titles in the two tables now
appear in a boldface font.
Trouble? Some of the title text may appear truncated within their cells. You’ll fix this