Changing Data Font and Color

Changing Data Font and Color

You can change the color of numbers and text on a worksheet. The strategic use of font color can be an effective way of visually uniting similar values. For example, on a sales worksheet you might want to display sales in blue and returns in red. The Font Color button on the Formatting toolbar displays the last font color you used. To apply this color to another selection, simply click the button. To apply a different color, click the Font Color button list arrow, and then select a color.

Change Font Color Using the Formatting Toolbar

Select a cell or range that contains the text you want to change.

Click the Font Color list arrow on the Formatting toolbar.

Click a color.

Change Font, Font Style, and Font Size

Select a cell or range that contains the font you want to change.

Click the Format menu, and then click Cells .

Click the Font tab.

Select a font.

Select a font style.

Select a font size.

Select any additional formatting effects.

Click OK.