Excel Semi Pro
ArticlesFunctionsAI in Excel

Names Articles

Articles tagged Names, including related tutorials, examples, and walkthroughs.

4 articles

FormulasIntermediate
2012-04-09

A 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-25

A 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-06

Hide 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-28

Enter 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
Excel Semi-Pro

Practical Excel guides, formula references, and AI integration tutorials for intermediate users who want to work faster and smarter.

Content

  • All Articles
  • Functions Reference
  • AI in Excel
  • RSS Feed

The Blog

  • About
  • Contact
  • Privacy Policy

Topics

  • Formulas
  • Beginner
  • Advanced
  • Time and Date
© 2026 Excel Semi-Pro. All rights reserved.
Tips, guides, and references for Excel users.Privacy Policy