Excel 2010 Bible

Chapter 16: Introducing Array Formulas

367

FIGURE 16.8

Creating an array from a range.

Creating an array constant from values in a range ...................................................

In the preceding example, the array formula in D8:F11 essentially created a link to the cells in

A1:C4. It’s possible to sever this link and create an array constant made up of the values in A1:C4:

1. Select the cells that contain the array formula (the range D8:F11, in this example).


2. Press F2 to edit the array formula.


3. Press F9 to convert the cell references to values.


4. Press Ctrl+Shift+Enter to re-enter the array formula (which now uses an array
   constant).

The array constant is

{1,”dog”,3;4,5,”cat”;7,False,9;”monkey”,8,12}

Figure 16.9 shows how this looks in the Formula bar.

FIGURE 16.9

After you press F9, the Formula bar displays the array constant.