To change a cell's font, font style, font color, or background color
Select the cells you want to change.
On the Home tab, use the controls in the Font group to format the cells.
To add a border to a selected cell or cells
On the Home tab, in the Font group, click the Border arrow, and then in the list, click the type of border you want to apply.
To apply a style to a selected cell or cells
On the Home tab, in the Styles group, click Cell Styles.
Click a style.
To create a new style
On the Home tab, in the Styles group, click Cell Styles.
Click New Cell Style, and then type a new style name.
Click Format, specify the formatting you want the style to apply, and then click OK twice.
To delete a style
On the Home tab, in the Styles group, click Cell Styles.
Right-click the style you want to delete, and then click Delete.
To copy a cell's formatting onto another cell
Click the cell that contains the format you want to apply to another cell.
On the Home tab, in the Clipboard group, click the Format Painter button.
Select the cells to which you want to apply the formatting.
To change theme fonts, colors, and graphic effects
Using the Controls on the Page Layout tab, in the Themes group, follow one of these steps:
Click the Fonts button, and then select a new font.
Click the Colors button, and then select a new color set.
Click the Effects button, and then select a new default effect.
To apply a workbook theme
On the Page Layout tab, in the Themes group, click Themes.
Click the theme you want to apply.
To save a workbook's format as a new theme
Format your worksheet using the colors, fonts, and effects you want to include in your theme.
On the Page Layout tab, in the Themes group, click Themes.
Click Save Current Theme.
Type a name for your theme.
Click Save.
To create a new table style
On the Home tab, in the Styles group, click Format as Table, and then click New Table Style.
In the Name field, type a name for the table style.
In the Table Element list, click the element you want to format.
Click Format, and use the controls in the Format dialog box to format the table element. Then click OK.
Repeat as desired to format other elements, and then click OK.
To format a cell value as a phone number
On the Home tab, click the Number Dialog Box Launcher.
Click Special, click Phone Number, and then click OK.
To format cell data as a currency value
On the Home tab, in the Number group, click the Accounting Number Format button.
To select a foreign currency symbol
On the Home tab, in the Number group, click the Accounting Number Format arrow, and then in the list, click the currency symbol you want to apply.
To add words to a cell's value
On the Home tab, click the Number Dialog Box Launcher.
Click Custom, and then click the format to serve as the base for your custom format.
Type the text to appear in the cell, enclosed in quotes, for example, "cases," and then click OK.
To apply a conditional format to selected cells
On the Home tab, in the Styles group, click Conditional Formatting.
Click New Rule.
Click Format Only Cells That Contain. In the Comparison Phrase list, click the comparison phrase you want. Then type the constant values or formulas you want evaluated.
Click Format, specify the formatting you want, and then click OK twice.
To edit a conditional formatting rule
Select the cells that contain the rule you want to edit.
On the Home tab, in the Styles group, click Conditional Formatting.
Click Manage Rules, click the rule you want to change, and then click Edit Rule.
Make your changes, and then click OK twice to save them.
To delete a conditional formatting rule
Select the cells that contain the rule you want to delete.
On the Home tab, in the Styles group, click Conditional Formatting.
Click Manage Rules, click the rule you want to delete, click Delete Rule, and then click OK.
To display data bars in selected cells
On the Home tab, in the Styles group, click Conditional Formatting.
Point to Data Bars, and then click the data bar option you want to apply.
To display a color scale in selected cells
On the Home tab, in the Styles group, click Conditional Formatting.
Point to Color Scales, and then click the color scale pattern you want to apply.
To display icon sets in selected cells
On the Home tab, in the Styles group, click Conditional Formatting.
Point to Icon Sets, and then click the icon set you want to apply.
To add a picture to a worksheet
On the Insert tab, in the Illustrations group, click Picture.
Navigate to and double-click the picture you want to insert.
To change thea selected picture's characteristics
Use the controls on the Format tab to edit the picture.