Create a Drop Down List within a Cell

One of the tricks you can use when creating a nice dashboard or Excel template is to add a drop-down list to a cell using Data Validation. You can reference a list from a different worksheet as long as you define the list as a Named Range. In my new article, "Drop Down List using Data Validation", I explain how to do it.