Excel: Redefining a Name to Refer to a New Range of Cells

Last reviewed: October 31, 1994
Article ID: Q29323

SUMMARY

To redefine a name to refer to a different range of cells, do one following:

Method 1

Select the new range of cells.
From the Formula menu, choose Define Name.
Retype the name for this range of cells. Click OK.

Method 2

From the Formula menu, choose Define Name.
Select the name to be changed.
In the Refers To box, type the new range of cells.

You can also use the Create Names command (on the Formula menu when Full Menus is selected). If a name is already defined, Excel presents a dialog box that asks if you want to replace the existing definition of the name. If you click "Yes," the name takes on the new definition.

KBCategory: kbother
KBSubcategory:
Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

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