Microsoft KB Archive/41032

From BetaArchive Wiki

Excel: Pasting Defined Names from One Worksheet to Another

Last reviewed: October 31, 1994
Article ID: Q41032


In Microsoft Excel, when a cell containing a formula that uses a defined name is pasted into a new worksheet, the defined name is also pasted into the destination worksheet.

For example, in the source worksheet, cell A1 is named "myName" (myName is set equal to $A$1) and cell A2 contains the formula "=myName". When the formula is pasted into cell A10 on the destination worksheet, the destination worksheet lists "myName" as a defined name defined as $A$1.

KBCategory: kbother


Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

Last reviewed: October 31, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.