Instantly Paste list of Defined Named Ranges in Excel workbook – Quick Tip


Excel’s “Named ranges” feature is a love at first sight! And whoever know how they work would agree and must be loving them every bit. And case with us humans is that whatever we love we do it over and over again!

Now think for a moment that you have a workbook or better yet a dashboard report where you have defined many names and I mean MANY! And now you need to know all of them. Wish there is a way that we can obtain all of the names in a list.

Your wish is actually a command that Excel knows very well.

To obtain all the defined named ranges as a list, simply select the cell of your desire and then go to Formula tab > Defined Names group > click Use in formula drop down button > click paste names. A new dialog box will appear. Click Paste list button and you are done!

paste name list


Checkout following tutorials to see Excel Named Ranges in action:

  1. Excel Conditional LOOKUPs – Applying VLOOKUP on multiple ranges
  2. Creating Currency Converter in Excel [How To]
  3. Understanding, Detecting and Correcting Excel errors – #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!