Topic 4: Formatting Excel data according to your needs

[seema]

The Excel Formatting - Colors

To change the color of text

Select the cells containing the data you want to change the color. On the Excel Formatting toolbar, click the down arrow next to the Font Color icon. Choose a color from the Font Color palette. The color you selected from the Font Color palette will be displayed on the new icon face. Click on the icon face to apply the new color to the cell.

[seema]

To apply colors to cell(s)

Select the cell or range of cells you wish to color. On the Excel Formatting toolbar, click the down arrow next to the Fill Color icon. Choose a color from the Fill Color palette. To turn off the cell(s) color Select the cell or range of cells you wish to color. On the Excel Formatting toolbar, click the down arrow next to the Fill Color icon. Choose No fill.

[seema]

The Excel Formatting - Numbers

To change number formatting using the formatting icons

You can quickly change the formatting of a cell or selected range by using the following icons on the Formatting toolbar. Currency 12345 will become $12,345.00 Percent .25 will become 25% Comma 98765 will become 98,765.00 Increase Decimal 12,345.00 will become 12,345.000 Decrease Decimal 98,765.00 will become 98,765.0

[seema]

To format a number as a currency

Select the cell or range of cells you want to format.
From the Format menu, click Cells.
From the Format Cells dialog box displayed, select the Number tab.
In the Category: section, select Currency.

Select the number of decimal places you require by using the Decimal places: spin box arrows.
In the Symbol: section drop down list, select the type of currency.
Click OK.

[seema]

To format a number as a percentage

Select the cell or range of cells you wish to format. From the Format menu, click Cells. From the Format Cells dialog box displayed, select the Number tab. In the Category: section, select Percentage. Select the number of decimal places you require by using the Decimal places: spin box arrows. Click OK.