Microsoft Office Tutorials and References
In Depth Information
Figure 14-8: Creating an array from a range.
Creating an array constant from values in a range
In the previous example, the array formula in D8:F11 essentially created a link to the cells in A1:C4. It's pos-
sible to sever this link and create an array constant made up of the values in A1:C4.
To do so, select the cells that contain the array formula (the range D8:F11, in this example). Press F2 to edit the
array formula and then press F9 to convert the cell references to values. Press Ctrl+Shift+Enter to reenter the ar-
ray formula (which now uses an array constant). The array constant is as follows:
Figure 14-9 shows how this looks in the Formula bar.