Friday, 14 September 2012

Use a Range Name in a Formula

Select a range. Give it a name in name box and press Enter
Give it a name in name box
Type '=SUM(' in A16
Type '=SUM(' in A16
Press F3 to display a list of named ranges.
Press F3 to display a list of named ranges.
Click the name of the range you want to insert. Click OK.
Click the name of the range you want to insert. Click OK.
Complete the formula by entering a close parentheses.
 Then click the Enter button.
Complete the formula by entering a close parentheses. Then click the Enter button.

No comments:

Post a Comment