First of all open your excel sheet and select the cell on which you wish to create a drop down.And today I will guide you on making a drop down list in Excel. This approach is better because it validates each input from user against a predefined set of values and hence users can only input valid and excepted values.Įxcel also has a feature that allows you to create drop down lists. It is always good to have drop down lists for accepting user inputs. Drop down list is a tool that can help you to force users into selecting a specific value from a predefined set of values.
0 Comments
Leave a Reply. |