Names | Excel Semi-Pro

Names

A Dynamic Dependent Drop Down List with a Horizontal Table Reference

April 9, 2012 Formulas

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 I’ve already detailed how this is done in the article mentioned above, I’ll keep this short. The screen shot below is what I’ll be referencing. At the […]

Get the full story …

A Dynamic Dependent Drop Down List in Excel

May 25, 2011 Formulas

The other day I was reading a post over at the Contextures blog about Dynamic Dependent Excel Drop Downs and realized that using an Excel Table would provide an alternative method that is both simple and flexible. Tables are available in Excel versions 2007, 2010, and 2011. In this post I’ll create a Table to […]

Get the full story …

Hide or Show Names in Excel with VBA

November 6, 2010 Advanced
Thumbnail image for Hide or Show Names in Excel with VBA

If you’ve discovered how useful Names can be in a spreadsheet, you may also know they can get-in-the-way-if-you-have-too-many. Just check out the Name Box in the picture to the right. Each Name has a Visible property that’s set to TRUE by default. You can hide a Name by changing the Visible property to FALSE, but […]

Get the full story …

Enter a Constant Value in a Name

September 28, 2010 Formulas
Thumbnail image for Enter a Constant Value in a Name

Once upon a time I was working with an unfamiliar Excel spreadsheet and came across a formula that used a Name, which I figured for a constant value and thought it hidden somewhere in the worksheet, yet couldn’t find it anywhere. It never dawned on me that a value doesn’t have to reside in a […]

Related Posts Plugin for WordPress, Blogger...
Get the full story …