Forum Discussion
AstroGuy
Feb 20, 2022Copper Contributor
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...
JKPieterse
Feb 21, 2022Silver Contributor
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.
John_Hardy
Dec 07, 2022Copper Contributor
the question is how to do this on a mac office 365? there is no formula tab
- JKPieterseDec 07, 2022Silver Contributor
John_Hardy There should be:
- John_Hardy2400Dec 07, 2022Copper ContributorThank you but unfortunately that’s not what I see. Formulas tab is not there.
- JKPieterseDec 07, 2022Silver ContributorPerhaps you are using an older version?