Filtering

SS
Clear filter -
Names scoped to worksheet - Displays only those names that are specific to the active worksheet.
Names scoped to workbook - Displays only those names that have a workbook level scope.
Names with errors - Displays only those names that contain any of the following error values (#VALUE!, #REF!, #NAME).
Names without errors - Displays only those names that do not contain any error values.
Defined Names - Displays only those names defined by you. This option will also include built-in named ranges created by Excel for example print_area.
Table Names - Displays only table names.