Cannot Evaluate 3-D References Using F9 Key

MORE INFORMATION

Microsoft Excel allows you to evaluate part of a formula in order to see how that part of the formula is handled when the formula is entered. To see how this feature of Microsoft Excel works, do the following:

1. In a new worksheet, enter the following values:

   A1: 1 B1: =SUM(A1:A3)
   A2: 2
   A3: 3

2. Select cell B1.
3. In the formula bar, select A1:A3.
4. Press the F9 key.

Note that the "A1:A3" disappears and is replaced by "{1;2;3}". This indicates that the range A1:A3 is evaluated to the array of values 1, 2, and 3. (To return to editing mode, press the ESC key.)