Formatting Text and Numbers

Formatting Text and Numbers

Sometimes you want to format cells with labels differently from cells with totals. You can change the appearance of data in selected cells without changing its actual label or value. Format text and numbers by using font attributes , such as boldface, italics, or underlines, to enhance data to catch the readers' eye and focus their attention. You can also apply numeric formats to values to better reflect the type of information they present ”dollar amounts, dates, decimals, or percentages.

Format Text Quickly

Select a cell or range with the text you want to format.

Click one of the buttons on the Formatting toolbar to apply that attribute to the selected range:

• Bold

• Italic

• Underline

Click the Font or Font Size list arrow, and then select a font or size.

You can apply multiple attributes to the range.

Format Numbers Quickly

Select a cell or range with the numbers to format.

Click one of the buttons on the Formatting toolbar to apply that attribute to the selected range.

• Currency Style

• Percent Style

• Comma Style

• Increase Decimal

• Decrease Decimal

You can apply multiple attributes to the range.

Apply Numeric, Date, and Time Formats

Select a cell or range with the numbers to format.

Click the Format menu, and then click Cells.

Click the Number tab.

Click a numeric, date, or time category.

Select the formatting type options you want to apply.

Preview the sample.

Click OK.

Did You Know?

Excel has formatting intelligence . As you type at the end of a column or row, Excel extends the formatting and formulas you are using in that column or row.

You can use AutoFormat to save time . An AutoFormat is a combination of ready-to-use, designed formats. Select the cell or range you want to format, click the Format menu, click AutoFormat, click a format style, and then click OK.