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:
AVERAGE function is used to get the average of numbers. Function applies formula i.e. average = Sum of all values / (Divided by) number of items.
What is Strikethrough in Excel? Strikethrough in Excel is a feature that lets you draw a line through text. It’s like crossing something out, usually to show that it’s no longer needed or has been…
How to find duplicates in excel? Hope you read the post “Remove Duplicates in Excel”. Now I am going to explain how you can find these duplicates. There are multiple methods available to Find and…
What is Pareto Chart? Pareto principle was introduced by Italian Economist Vilfredo Pareto. He stated that 80% of the effects are caused by 20% of the causes. So if we closely monitor and solve 20% of…
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells…
Undo in excel very useful If you’re new to Excel or even if you’ve been using it for a while, you’ve probably made a mistake on a spreadsheet. Mistakes happen a lot, especially when working…