Microsoft Excel is what most professionals are using for their day-to-day office.
Creating a drop-down list in Microsoft Excel can make it easier for the microsoft excel user to enter data.
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:
Create Dynamic Data Validation List When I started my career in working with excel dashboards, I always used to face most common challenge in “Data Validation” technique where I want a smart data validation to avoid all…
In layman language, this chart divides the data into multiple range groups with same interval i.e. 1-5, 5-10… and then plot the data into these groups to find the distribution among these group. So that you may understand, what are the major areas which has large impact or your major data fall. This helps the user to understand the nature of your data
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…
How to Hide Ribbon &Formula bar in excel? While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and…
How to protect and share your workbook? Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to…
How to Insert Symbol in Excel? I came across many queries regarding inserting special symbols in Excel. Here we are guiding how you may do this quickly in excel. Follow these steps and you may…