How to View Named Ranges in Microsoft Excel ?

Named range is a very useful feature in Excel especially when you work with lot of formulas but there are times when you might want to view the list of all the named ranges in your workbook. There are couple of ways in which you can view the named ranges in Excel.

How to View Named Ranges in Microsoft Excel ?

Option 1 : Name Manager Dialog window.

You can use the Name Manager Dialog Window to view all the names. Just select “Name Manager” from the Formulas tab in your Excel.

image

You should see the list of all the Names Ranges used.

SNAGHTML950191

Option 2 : Using the Use in Formula drop-down list

Click the “Use in Formula” drop-down list from the “Formula” Tab as shown in the screenshot which should display the list of all the named ranges use din the workbook.

image

Leave a Reply