Today in this article you learn how to make a drop-down menu in Excel. A drop-down menu is also known as a drop-down list.
Brief Definition of drop-down menu/drop-down list
A drop-down list is a graphical control element, similar to a list box, that allows the user to choose one value from a list. When a drop-down list is inactive, it displays a single value. When activated, it displays a list of values, from which the user may select one.
How To Make A Drop Down Menu In Excel: A drop-down menu is a handy option for office work; you can easily create a drop-down menu less than 60 seconds.
First Step: Go to the Data tab
Second Step: Click on Data Validation
Third Step: Select “List” option from the drop-down menu
Final Step: In the source, section select the list source (from excel sheet) or manual enter drop-down list (Like Absent, Parents, Holiday)
Mostly dropdown using for filling the pre define remarks, and you can use for making attendance sheet.
Read More
