Microsoft Office Tutorials and References

In Depth Information

**Using arrays**

Figure 12-32
We entered a single array formula in the selected range F4:F8.

You’ll find the Arrays.xlsx file with the other examples on the companion website.

This particular example might be used to help protect the formulas from tampering

because modifying individual formulas in cells that are part of an array is impossible. To

enter this formula, do the following:

Select the range F4:F8.

1.

Type the formula in the formula bar, as shown in Figure 12-32.

2.

Press Ctrl+Shift+Enter.

3.

The resulting single array formula exists in five cells at once. Although the array formula

seems to be five separate formulas, you can’t make changes to any one formula without

selecting the entire formula—that is, the entire array range F4:F8.

You can identify an array formula by looking at the formula bar. If the active cell contains

an array formula, the entire formula, including the equal sign, is enclosed in curly braces—

{ }—in the formula bar, as you can see in Figure 12-32.