Excel XP

Introduction

By the end of this lesson, learners should be able to:

• Apply fonts
• Apply a font color
• Apply borders

Change font type, size and color

In Excel XP a font consists of three elements: Typeface, or the style of the letter; Size of the letter; and Color of the letter. The default font in a spreadsheet is Arial 10 points, but the typeface and size can be changed easily.

Selecting a Font Typeface:

The amount of typefaces available for use varies depending on the software installed on your computer.

To Apply a Typeface to Information in a Cell:

• Select a cell or range of cells.
• Click on the down arrow to the right of the Font Name list box on the Formatting toolbar.
  
  
  
  
• A drop-down list of available fonts appears.
  
  
  
  
• Click on the Typeface of your choice.
• The selection list closes and the new font is applied to the selected cells.

Change font type, size and color (continued)

To Apply a Font Size to Information in a Cell:

The "Font Size" list varies from typeface to typeface. The Arial font sizes, for example, are 8, 9, 10, 11, 12, 14, 16, 18, 20, 22, 24, 26, 28, 36, 48, 72.

• Select a cell or range of cells.
• Click on the down arrow to the right of the font size list box on the Formatting toolbar.
  
  
  
  
• A drop down list of available font sizes appears.
  
  
  
  
• Click on the Font Size of your choice.
• The selection list closes and the new font size is applied to the selected cells.

Change font type, size and color (continued)

To Apply Color to Information in Cells:

• Select a cell or range of cells.
• Click on the down arrow to the right of the font color list box.
  
  
  
  
• A drop-down list of available colors appear.
  
  
  
  
• Click on the color of your choice.
• The selection list closes and the new font color is applied to the selected cells.

Underline, italics and bold

In addition to the typeface, size and color, you can also apply Bold, italics, and/or underline font style attributes to any text or numbers in cells.

To Select a Font Style:

• Select a cell or range of cells.
• Click on any of the following options on the Formatting toolbar.
  
  
  
  
• Bold button (Ctrl + B).
• Italics button (Ctrl + I).
• Underline button (Ctrl + U).
  
  
• The attribute(s) selected (bold, italics, or underline) are applied to the font.

The Bold, Italics, and Underline buttons on the Formatting toolbar are like toggle switches. Click once to turn it on, click again to turn it off.

Design and apply styles

Styles can save a lot of time when formatting a spreadsheet. A Style is a unique collection of font attributes (Number, Alignment, Font, Border, Patterns and Protection). Many different styles can be created in a spreadsheet, each with different attributes and names. When applied to a cell, information in it resembles the attributes defined for that style.

To Apply a style:

• Select the cell or range of cells.
• Choose Format Style from the menu bar.
  
  
  
  
• Select a style from the Style name drop-down list.
  
  
  
  

You can change the style attributes (Number, Alignment, Font, Border, Patterns and Protection) for any Style Name.

You can create new styles by clicking on the Add button in the Style dialog box.

Adding a border to cells

Borders can be applied to cells in your worksheet in order to emphasize important data or assign names to columns or rows.

To Add a Border to a Cell or Cell Range:

• Select a cell or range of cells.
• Click on the down arrow next to the Borders button.
• The Border drop-down appears.
  
  
  
  
• Choose a borderline style from the Border drop-down menu.
  
  
  
  
• The selected cells display the chosen border.

Adding Color to Cells

Colors can be applied to cells in your worksheet in order to emphasize important data or assign names to columns or rows.

To Add Color to a Cell:

• Select a cell or range of cells.
• Click the down arrow next to the Font Color button. A Font Color drop-down menu displays.
  
  
  
  
• Choose a font color from the Font Color drop-down menu.
  
  
  
  
• The selected cells display the color.

Challenge

• Type the label, "Learning about fonts in Excel," in cell B2.
• Change the font in cell B2 to have a typeface of Times New Roman, a size of 16 and a color of red.
• Type the word, "Underline," in cell B3 and apply an underline treatment to it.
• Type the word, "Italics," in cell B4 and apply an italics treatment to it.
• Type the word, "Bold," in cell B3 and apply a bold treatment to it.
• Select a cell range that includes cells B2, B3, B4 and B5.
• Add a border around the cell range.
• Define a color of yellow around the cell range.