EXCEL SHEET sometimes said as balance sheet is basically a way to maintain the fact & figures or all the documentation related to the organization .
If you are struggling to add drop-down list in excel sheet, then
for example: rows have following values a, b, c and d. And you want a drop down list on top of these rows to display all these mentioned values then we need to follow the below steps
.
1. Click on the Data tab (present on top of the excel) and click on Data validation tab.
2. Under setting tab (default tab in data validation window), and select List item from Allow drop down field.
Note: Make sure you have selected the cell in excel where you want to add the drop down list
field.
.jpg)
.jpg)
If you are struggling to add drop-down list in excel sheet, then
for example: rows have following values a, b, c and d. And you want a drop down list on top of these rows to display all these mentioned values then we need to follow the below steps
.
1. Click on the Data tab (present on top of the excel) and click on Data validation tab.
2. Under setting tab (default tab in data validation window), and select List item from Allow drop down field.
Note: Make sure you have selected the cell in excel where you want to add the drop down list
field.
0 comments:
Post a Comment