Quizzes & Puzzles3 mins ago
excel
2 Answers
how do you put text into the combo drop down box?
Answers
Best Answer
No best answer has yet been selected by solarearth. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.First you need to create your list of items in a blank part of your worksheet.
Then Go to the cell where you want the drop down list to appear. Then go to Data > Validation. In the "allow" box select "List"; in "Source" select the range of the list you created and click OK. This will give you a drop down list in that cell.
Not sure if that's what you want!
Then Go to the cell where you want the drop down list to appear. Then go to Data > Validation. In the "allow" box select "List"; in "Source" select the range of the list you created and click OK. This will give you a drop down list in that cell.
Not sure if that's what you want!