In Excel, there are various ways to provide a drop-down menu in a form or in cells. With drop-down menus, also called combo boxes, you can select an option based on pre-selected data. Samples of data where drop-dowm menus will be useful are gender (Male and Female options), Status (Single, Married, Divorced, etc options) and many others. The major reasons for providing a combo box or drop-down selection menu includes the following: On the other hand, combo boxes or drop-down selection menus are only applicable when: In this article, I… Read More
Microsoft Excel: Using Data Validation to provide drop-down selection menu
