XL2000: Paste Function Does Not Enter Formulas As Arrays (214043)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q214043

SYMPTOMS

When you use the Paste Function command in Microsoft Excel 2000, you cannot automatically enter a function as an array.

WORKAROUND

To enter an array formula when you use the Paste Function command, follow these steps:
  1. Start Excel and create the following spreadsheet:
       A1: 1   B1: 7
   A2: 2   B2: 3
   A3: 3   B3: 6
   A4: 4   B4: 2
  2. Select cells D1:E5.
  3. On the Insert menu, click Function or click Paste Function on the standard toolbar.
  4. Under Function category, click All.
  5. Under Function name, click LINEST.
  6. Click OK.
  7. Type the following values into the appropriate boxes:
       Known_y's   A1:A4
   Known_x's   B1:B4
   Const       TRUE
   Stats       TRUE
  8. Click OK.
  9. The number -0.35294 appears in cell D1, and all the other cells in the array are unpopulated.
  10. Press F2, and then press CTRL+SHIFT+ENTER. The entire range is now filled by a single array formula, which displays the correct values.
Modification Type:MajorLast Reviewed:10/8/2003
Keywords:kbprb KB214043
©2003 Microsoft Corporation. All rights reserved.