Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

If you’ve created a number of range names in an Excel 2010 worksheet, you can use the Name Manager to work with these names. The Name Manager provides a list of all names assigned in the current workbook, and you can filter, modify, or delete them as needed. You also can use the Name Manager to create new range names.

Follow these steps to manage your range names in Excel 2010:

  1. On the Formulas tab, click Name Manager in the Defined Names group (or press Ctrl+F3).

    The Name Manager dialog box appears.

  2. Select one of the following options:

    • Click the New button, which displays the New Name dialog box in which you can enter a range name and enter the cell location it refers to.

      Instead of typing the range cell locations, click the Collapse button, which moves the New Name dialog box aside. You can then use your mouse to select the desired cell(s). Press Enter or click the Expand button to return to the New Name dialog box.

    • Click an existing range name and then click the Edit button, which displays the Edit Name dialog box. Use this dialog box to change the range name or the range cell location reference.

    • Click an existing range name and then click the Delete button. A confirmation message appears, making sure you want to delete the range name.

      Use the Edit Name dialog box to change the name or location of a range name.
      Use the Edit Name dialog box to change the name or location of a range name.
  3. Click the Close button to close the Name Manager dialog box.

If you have a lot of range names, you can click the Filter button in the Name Manager dialog box and elect to display only the items meeting selected criteria, such as Table Names, Names with Errors, or Defined Names.

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: