Microsoft KB Archive/214043

= XL2000: Paste Function Does Not Enter Formulas As Arrays =

Article ID: 214043

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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:   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.</li>  Type the following values into the appropriate boxes: <pre class="fixed_text">  Known_y's   A1:A4 Known_x's  B1:B4 Const      TRUE Stats      TRUE </li> Click OK.</li> The number -0.35294 appears in cell D1, and all the other cells in the array are unpopulated.</li> Press F2, and then press CTRL+SHIFT+ENTER. The entire range is now filled by a single array formula, which displays the correct values.</li></ol>

Additional query words: XL2000

Keywords: kbprb KB214043

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.