List "Defined Names"

List Defined Names

If you are like me, when you finish the project you will be lost with all the components of your dashboard, more importantly, when a change needs to be perform you need time to study the dashboard again, or, your colleagues will be lost, in particular when you build the dashboard using “defined names”.

Now, how do you keep track of all these names?

Thankfully, there is just the feature for this, called as “paste names“.

This is how it works.

·         Insert a new worksheet

·         Press F3 (Paste Name dialogue will be displayed)

 

·         Click Paste List

Eureka!!