excel

[solarearth]

how do you put text into the combo drop down box?

[SpamBammer]

bit vague,

which drop down box?

[Aquariel]

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!