XL2000: Paste Function Does Not Enter Formulas As Arrays

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.

To enter an array formula when you use the Paste Function command, follow these steps:

Start Excel and create the following spreadsheet:

   A1: 1   B1: 7
   A2: 2   B2: 3
   A3: 3   B3: 6
   A4: 4   B4: 2

Select cells D1:E5.
On the Insert menu, click Function or click Paste Function on the standard toolbar.
Under Function category, click All.
Under Function name, click LINEST.
Click OK.

Type the following values into the appropriate boxes:

   Known_y's   A1:A4
   Known_x's   B1:B4
   Const       TRUE
   Stats       TRUE

Click OK.
The number -0.35294 appears in cell D1, and all the other cells in the array are unpopulated.
Press F2, and then press CTRL+SHIFT+ENTER. The entire range is now filled by a single array formula, which displays the correct values.

Keywords: KB214043, kbprb

Article Info