Excel Semi-Pro
How to Use Microsoft Excel. Learn Online.
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 …
Continue Reading about A Dynamic Dependent Drop Down List with a Horizontal Table Reference →
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 …
Continue Reading about A Dynamic Dependent Drop Down List in Excel →
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 …
Continue Reading about Hide or Show Names in Excel with VBA →
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, …
