The objective of creating drop-down list is to give an option to a user to select the option from the list.
so that it restricts the user to select unwanted entries input.
we can also use drop-down option for creating interactive dashboards for reporting purpose.
STEP 1 :- As we can see on the top we have a data entry form at the bottom we have a dashboard
STEP 2 :- So for creating a drop-down list select a cell and go to data under this data there is data validation icon.
now click on the data validation and the screen will pop up shown below.
STEP 3 :- Now under the setting option click the allow button and select the list. now in source write the entries for eg india, united states, china etc we can add as many countries than click ok.
STEP 4 :- Now after this, if we select any cell there is a dropdown list of entries like India,united states, china, etc. so our drop-down list is updated.
Now let us understand how to create a drop-down from the list because whenever we have big data sets than it is not easy to write manually every entry. In this case, We will follow the steps given below.
Step 1: Select the cells containing the headings and values
Step 2: Click on “Data” on the top of excel and select Data Validation:
Step 3: Select List under “Allow” and enter the Range of your data under “Source”. Click Ok:
Note: In order to fix the range, you need to use “$” sign before Column and Row reference values i.e. $A$2:$A$8
Step 4: Here is your drop down list:
Microsoft Excel “ISBLANK Function” is a Logical Function and it is used to check if cell in question is “BLANK OR NON-BLANK”. “ISBLANK Function” is used as a test to validate if cell contains any…
REPT function is used to repeat the text or cell reference to multiple times
COUNT function is used to get the total count of Number values in range or list.COUNT Function has one required and optional arguments.
Watch: How to use WEEKNUM Function in Excel? What is WEEKNUM Function? The WEEKNUM function in Excel returns the week number of a given date. It is a DATE and TIME function that can be…
Generate Random Numbers in Excel Using RAND We have got many instances where we needed to generate a random database or values. Rand function is very useful for the users who creates random database for…
Introduction Welcome to this comprehensive guide on using Power Query in Excel to split data efficiently. In this tutorial, we’ll walk you through the step-by-step process of splitting columns, specifically focusing on splitting the name…