Excel: Sounds Good (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

 

 

Formulas ->Name Manager

Name Manager Options

You can use the Named Manager to create, edit and delete a Named Range. A good working spreadsheet may have dozens of Named references. One of the coolest tools is the Filter.

 

The Filter lets you choose to see the Names in one worksheet, or in the whole workbook. It includes Table Names as well.

 

Try It: Filter the Names

Go to Formulas->Name Manager.

Click on Filter.

 

Do you have any Names with Errors?

 

  Microsoft Excel 2007 Exam 77-602 Topic: 3.   Creating and Modifying Formulas

  3.1. Reference data in formulas 

  3.1.3. Manage named ranges: Delete a named range