XL98: Microsoft Excel Inserts a Defined Name in FormulaLast reviewed: February 25, 1998Article ID: Q181706 |
The information in this article applies to:
SYMPTOMSIn Microsoft Excel 98 Macintosh Edition, if you type a formula and click a cell in order to add the cell address to the formula, a defined name may appear in the formula instead of the address of the cell you clicked.
CAUSEThis behavior may occur if the cell you click is a cell that is referenced by a defined name. In this case, Microsoft Excel 98 Macintosh Edition inserts the valid defined name.
WORKAROUNDTo work around this behavior, manually type the cell address in the formula. For example, to type a formula in cell B1, instead of typing an equal sign (=) and clicking cell A1, type "=A1" (without the quotation marks), and then press RETURN. It is not possible to prevent Microsoft Excel 98 Macintosh Edition from inserting the defined name if you click a cell that is referenced by a defined name.
MORE INFORMATIONIn earlier versions of Microsoft Excel, if you click a cell while typing a formula, the relative address of the cell appears in the formula. This is true even if the cell you click is referred by one or more defined names. Microsoft Excel 98 Macintosh Edition behaves differently. If you click a cell while typing a formula, the relative address of the cell appears in the formula unless the cell is referred by a defined name. If the cell is referred by a defined name, the defined name appears in the formula instead of the cell address.
ExampleTo see an example of this behavior, follow these steps:
|
Additional query words: XL98 apply
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |