To create a named range
To create a named range from a selection
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 that represents the cell that contains the range’s desired name.
Click OK.
To display the 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.
Click the Edit button.
Click the Collapse Dialog button.
Select the cells you want in the range.
Click Close.
To create a formula
To create a formula 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 click OK.
Fill in the Function Arguments dialog box, and click OK.
To use a named range in a formula
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( would be a valid way to start.
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 using Formula AutoComplete
To create a formula that doesn’t change when copied between cells
To create a formula that does change when copied between cells
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.
Type the text you want to appear if the condition is false.
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.
Click Close.
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.
Click Add.
Click Watch Window.
To delete a watch