Names Articles
Articles tagged Names, including related tutorials, examples, and walkthroughs.
4 articles
FormulasIntermediate
2012-04-09A Dynamic Dependent Drop Down List with a Horizontal Table Reference
I received a comment asking if a dynamic dependent drop-down list in Excel could have a list where the "table headers were actually rows and not columns?" Since...
#excel-legacy#excel-for-mac#names
3 min read
Read Article
FormulasIntermediate
2011-05-25A Dynamic Dependent Drop Down List in Excel
Learn how to create dynamic dependent drop-down lists in Excel....
#excel-legacy#excel-for-mac#names
6 min read
Read Article
Advanced
2010-11-06Hide or Show Names in Excel with VBA
Names can be hidden or shown in Excel with some simple VBA code....
#names#vba
4 min read
Read Article
FormulasIntermediate
2010-09-28Enter a Constant Value in a Name
Create a Name in Excel that holds a constant value....
#excel-for-mac#names
3 min read
Read Article
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us