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 cell
Select the cells around which you want to draw a border.
On the Home tab, in the Font group, click the Border button’s down arrow.
Click the type of border you want to apply.
To apply a style to a cell
Select the cells you want to change.
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.
Type a new style name.
Click Format.
Specify the formatting you want this style to contain.
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.
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 apply a workbook theme
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 select a new font.
Click the Colors button and select a new color set.
Click the Effects button and select a new default effect.
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.
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 group’s dialog box expander.
Click Special.
Click Phone Number.
Click OK.
To format cell data as a currency value
To select a foreign currency symbol
On the Home tab, in the Number group, click the Accounting Number Format button’s down arrow.
Click the currency symbol you want to apply.
To add words to a cell’s value
On the Home tab, click the Number group’s dialog box expander.
Click Custom.
Click the format to serve as the base for your custom format.
Type the text to appear in the cell, enclosed in quotes (e.g., "cases").
Click OK.
To apply a conditional format to a cell
Select the cells you want to change.
On the Home tab, in the Styles group, click Conditional Formatting.
Click New Rule.
Click Format Only Cells That Contain.
Click the Comparison Phrase down arrow, and then click the comparison phrase you want.
Type the constant values or formulas you want evaluated.
Click Format.
Specify the formatting you want and 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.
Click Edit Rule.
Use the controls to make your changes.
Click OK twice to save your changes.
To delete 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 delete.
Click Delete Rule.
Click OK.
To display data bars in one or more cells
Select the cells that contain your data.
On the Home tab, in the Styles group, click Conditional Formatting.
Point to Data Bars.
Click the data bar option you want to apply.
To display a color scale in one or more cells
Select the cells that contain your data.
On the Home tab, in the Styles group, click Conditional Formatting.
Point to Color Scales.
Click the color scale pattern you want to apply.
To display icon sets in one or more cells
Select the cells that contain your data.
On the Home tab, in the Styles group, click Conditional Formatting.
Point to Icon Sets.
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.
Double-click the picture you want to insert.
To change a picture’s characteristics