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.
Search JabSto ::




Custom Search