XL: Function Wizard Doesn't Enter Formulas as Arrays
ID: Q110862
|
The information in this article applies to:
-
Microsoft Excel 97 for Windows
-
Microsoft Excel for Windows, versions 5.0, 5.0c
-
Microsoft Excel for Windows 95, versions 7.0, 7.0a
-
Microsoft Excel for the Macintosh, versions 5.0, 5.0a
SUMMARY
When you use the Function Wizard in Microsoft Excel, you cannot
automatically enter a function as an array.
WORKAROUND
To enter an array formula when you are using the Function Wizard, do the
following:
- Select the range on your worksheet where the array formula is to be
entered.
- Use the Function Wizard to enter your formula. When your formula is
complete, choose the Finish button.
Your formula will now occupy a single cell (usually the upper-left
cell) in the range.
- In Microsoft Excel for Windows, press F2 and then press
CTRL+SHIFT+ENTER.
In Microsoft Excel for the Macintosh, press COMMAND+U, and then press
COMMAND+RETURN.
Your formula should now be entered as an array.
Additional query words:
97
Keywords : xlwiz xlformula
Version : MACINTOSH:5.0,5.0a; WINDOWS:5.0,5.0c,7.0,7.0a
Platform : MACINTOSH WINDOWS
Issue type :
|