Forum Discussion
Print list of Defined Names
I have an excel file in which I use over 80 defined named for different variables. I was careful to use a structured naming convention for the variable. I want someone else to be able to maintain it and evolve it over time. To help that person, I would like to give a little explanation of the variable name (something akin to a data dictionary).
I do not see a capability for the Excel name manager to export a list of the name to a file or an added sheet in the file of interest. surely, someone has been down this path.
- I highly recommend my free tool as SergeiBaklan has pointed you to already 🙂
That being said, you can get a quick list of range names using the Formulas tab, "Use in Formula" drop-down, "Paste Names" button and then click Paste List. Note that that will only paste names directly pointing to cells, names containing formulas will not be pasted.- the question is how to do this on a mac office 365? there is no formula tab
John_Hardy There should be:
With hundred of names perhaps this tool Free Name Manager Excel add-in (jkp-ads.com) by JKPieterse will be useful.
AstroGuy The very recently introduced Advanced Formula Environment could produce such a list. Search for it in the MS add-in list (Insert ribbon, Get Add-inns) and see it's available for your Excel version. If it is, then you can display a view like in the picture below.
Cut out the entire list and paste it in your data dictionary. It will also include named formulae.
Should this not work for you, Power Query can also list all named ranges (not named formulae) used within a workbook, though it does not include the ranges to which they refer.
