The usage of the drop-down list ensures that the input matches the correct spelling. Such cell entries return an error on applying the formula in Excel. For example, the name “Ravish,” is incorrectly typed as “Ravish ,” with an extra space at the end. In the absence of a drop-down excel list, there are chances of typing an incorrect response in the data file. This prevents the user from selecting options other than the listed ones. This prevents the user from typing manual entries, thereby reducing the occurrence of a garbage value in the data.įor example, to answer a set of questions in an online survey, the options provided in the drop-down list are “yes” and “no.” The user is expected to select any one of these answers. A drop-down list in excel is a pre-defined list of inputs that allows users to select an option. In simple terms, the response that the user can submit is limited to the options presented by the drop-down list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |