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:

  1. Select the range on your worksheet where the array formula is to be entered.


  2. 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.


  3. 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 :


Last Reviewed: October 30, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.