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...
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.
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:
- Thank you but unfortunately that’s not what I see. Formulas tab is not there.
- Perhaps you are using an older version?