Hello Friends
A drop-down list also known as a drop-down menu, drop menu, pull-down list, picklist is similar to a list box, that allows the user to choose one value from a list. These features provide us with a special way by which we can select the data of anyone element from the list box in a cell.
In this topic, I want to share with you how we can add a drop-down menu in the cell. It is very easy to create a drop-down list in Excel and once you understand these tricks, it will help you create a dashboard in excel.
Follow the steps to add a drop-down
1.Create/Enter a list. I have taken the list of the month in my example.
2. Select the cell where you want to enter the drop-down.
3. Click the " Data Validation" from the Data tab.
4. Data validate dialog box appears, select the list from the "Allow" drop-down menu. Choose the In-cell dropdown checkbox. Now enter the references of your data and click on OK.
5. Select the cell, now you can see the drop-down. You can select any one the data from the drop-down list.
You always have to change the reference in the source if you want to add any data to your list. If you want your drop-down list to be automatically updated if you add any data to your list. To learn the trick to create it follow the link Create Dynamic Drop-Down.
A drop-down list also known as a drop-down menu, drop menu, pull-down list, picklist is similar to a list box, that allows the user to choose one value from a list. These features provide us with a special way by which we can select the data of anyone element from the list box in a cell.
In this topic, I want to share with you how we can add a drop-down menu in the cell. It is very easy to create a drop-down list in Excel and once you understand these tricks, it will help you create a dashboard in excel.
1.Create/Enter a list. I have taken the list of the month in my example.
2. Select the cell where you want to enter the drop-down.
3. Click the " Data Validation" from the Data tab.
4. Data validate dialog box appears, select the list from the "Allow" drop-down menu. Choose the In-cell dropdown checkbox. Now enter the references of your data and click on OK.
You always have to change the reference in the source if you want to add any data to your list. If you want your drop-down list to be automatically updated if you add any data to your list. To learn the trick to create it follow the link Create Dynamic Drop-Down.
No comments:
Post a Comment