Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Change or delete a defined name
 
  1. On the Insert menu, point to Name, and then click Define.
  2. In the Names in workbook list, click the name you want to change.
  3. Do one of the following:
    • Change the name
      1. Type the new name for the reference, and then click Add.
      2. Click the original name, and then click Delete.
    • Change the cell, formula, or constant represented by a name

      Change it in the Refers to box.

    • Delete the name

      Click Delete.

advertisement