How to find and locate named ranges in Excel?

If you need to find and locate a certain named range in active workbook, you can click the arrow  in the Name box in Formula bar, and select the certain named range from the drop down list.

And then the certain named range is found and located as below screenshot shown:

If you have Kutools for Excel installed, you can switch to the Name manager pane with clicking the  button in the Navigation Pane, and then click the certain named range to find and locate it. See below screenshot:

Note: By default the Navigation Pane opens in the left of worksheets when you first installing Kutools for Excel. If you can’t view it, please turn on it by clicking Kutools > Navigation.

Both methods above can only find and locate one named range at a time. Here I will introduce Kutools for Excel’s Highlight Names utility to find and highlight all named ranges in active workbook quickly.

Click Kutools Plus > Worksheet Design to enable the Design tab, and then click the Highlight Names button on the Design tab. See screenshot:

Now all named ranges in active workbook are highlighted at once.

Note: This method is conditional formatting. If you create a new named range later, this new named range will be highlighted automatically too.