To create a named range from selected cells
To create a named range from a selection including the name
Select the cells you want to name as a range. Be sure either the first or last cell contains the name for the range.
On the Formulas tab, in the Defined Names group, click Create from Selection.
Select the check box for the cell that contains the name you want. Then click OK.
To display the Name Manager
On the Formulas tab, in the Defined Names group, click Name Manager.
To edit a named range
On the Formulas tab, in the Defined Names group, click Name Manager.
Click the named range you want to edit, and then click the Edit button.
Click the Collapse Dialog button, select the cells you want in the range, and then click Close.
To create a formula
To create a formula by using the Insert Function dialog box
On the Formulas tab, in the Function Library group, click Insert Function.
Select the function you want to use, and then click OK.
Fill in the Function Arguments dialog box, and then click OK.
To refer to a table column or row in a formula
Click the cell in which you want to create the formula.
Type =, followed by the function to include in the formula and a left parenthesis, for example, =SUM(.
Move the mouse pointer over the header of the table column you want to use in the formula. When the mouse pointer changes to a black, downward-pointing arrow, click the column header.
To create a formula that doesn't change when copied between cells
Precede all column and row references with a dollar sign, for example, $C$4.
To create a conditional formula
Click the cell in which you want to enter an IF function.
On the Formulas tab, in the Function Library group, click Logical, and then click IF.
Type a conditional statement that evaluates to true or false. Type the text you want to appear if the condition is true, and the text you want to appear if the condition is false. Then click OK.
To display cells that provide values for a formula
Click the cell you want to track.
On the Formulas tab, in the Formula Auditing group, click the Trace Precedents button.
To display formulas that use a cell's contents
Click the cell you want to track.
On the Formulas tab, in the Formula Auditing group, click the Trace Dependents button.
To remove tracer arrows
Click the cell you want to track.
On the Formulas tab, in the Formula Auditing group, click the Remove Arrows button.
To locate errors in a worksheet
On the Formulas tab, in the Formula Auditing group, click the Error Checking button.
Click the Edit in Formula Bar button.
Edit the formula.
Click the Next button to view the next error.
To step through a formula to locate an error
Click the cell with the formula you want to evaluate.
On the Formulas tab, in the Formula Auditing group, click Evaluate Formula.
Click Evaluate (one or more times) to move through the formula's elements.
To watch a value in a cell
On the Formulas tab, in the Formula Auditing group, click Watch Window.
Click Add Watch, select the cells you want to watch, and then click Add.
Click Watch Window.
To delete a watch
On the Formulas tab, in the Formula Auditing group, click Watch Window.
Click the watch you want to delete, and then click Delete Watch.