In this chapter, we will show how to develop dropdown lists or menus to control data entry and user choices available in the model. Dropdown lists can greatly facilitate data entry by limiting user entries and forcing users to choose a value from a controlled list. The data validation dialog box in the Excel’s Data tab is used to construct dropdown lists of various types and complexities.
Creating Simple Dropdown List
It is very helpful in financial models to be able to pick option from a dropdown menu of various options available in the model. For example, I have a worksheet that has products’ pricing scenarios under (a) Low Case, (b) Base Case, and (c) High Case. If I have a dropdown menu of these three pricing ...
Get Tips & Tricks for Excel-Based Financial Modeling, Volume II now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
