How to Show All Named Ranges in Excel

This post will guide you how to see all of the named cell ranges in an Excel Workbook. How do I list all named ranges in your current workbook in Excel.

There are many ways to check all named ranges in your workbook. Let’s see the following introduction.

List Name Ranges via Name Manager


If you created lots of name ranges in your workbook, and you want to see or check all of the named ranges. You can use Name Manager to achieve the result. Just do the following steps:

#1 go to FORMULAS tab in Excel Ribbon, and click Name Manager command under Defined Names group. And the Name Manager dialog will open.

show all named ranges1

#2 all of the named ranges would be listed in the name manager dialog.

show all named ranges2

List Name Ranges via Use in Formula


You can also list all of the named ranges from the Use in Formula Drop down menu list. Just go to Formula Tab, and click use in Formula command under Defined Names group. And all named ranges should be listed in the drop down list.

show all named ranges3

List Name Ranges via Name Box


You can also see all of the named ranges in the Name Box in your current worksheet. Just click the Name drop down list box.

show all named ranges4

 

List Name Ranges via Go To Feature


You can also to list all named ranges from Go To feature, just do the following steps:

#1 go to HOME tab, click Find & Select command under Editing group. And select Go To from the drop down menu list. And the Go To dialog will open.

show all named ranges5

#2 you should see that all defined Name ranges will be listed in Go to list box.

show all named ranges6

Video: List All Name Ranges

 

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar