Microsoft KB Archive/181308

= XL98: Name Box Functionality Has Changed =

Article ID: 181308

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q181308



SUMMARY
In earlier versions of Microsoft Excel, you can click the Name box, which is located on the formula bar, and select a defined name to use in a formula. In Microsoft Excel 98 Macintosh Edition, the functionality of this box changed; it is no longer possible to select a defined name from the list. In Microsoft Excel 98, this box is the Function box, which stores the most recently used functions.



MORE INFORMATION
Although you cannot change the functionality of the Name box so that it works as it does in earlier versions, you can replicate the earlier functionality. To do this, use the Go To dialog box to place a defined name in a formula.

Example
The following example uses the Go To dialog box to place a defined name in a formula. To do this, follow these steps:  Save and close any open documents then create a new file in Microsoft Excel.  Enter the following values in Sheet1:      A1: 1 A2: 2 A3: 3  Select cells A1:A3. On the Insert menu, point to Name, and then click Define. Type TestRange in the Names In Workbook box, and then click OK.

Cells A1:A3 are defined as TestRange. Select cell A5. Type the following:

=SUM(

</li> On the Edit menu, click Go To. Click TestRange in the Go To list, and then click OK.</li> Type ) to close the parentheses in the SUM formula, and then press ENTER.</li></ol>

The formula returns a value of 6.

This behavior also occurs when you use the Function Wizard. For additional information, please see the following article in the Microsoft Knowledge Base:

179035 XL98: Unable to Select Defined Names by Using Function Wizard

<div class="references_section">