Click the Formulas tab.
Click the Name Manager button.
Click the Filter button, and then select the filter command.
Names Scoped to Worksheet displays names local to a worksheet
Names Scoped to Workbook displays names global to a workbook
Names with Errors displays names with values that contain errors (such as #NAME, #VALUE, etc.)
Names without Errors displays names without errors
Defined Names displays names defined by you or by Excel
Table Names displays table names