Put the things you want in a column near where you are wanting to put your
drop down box if you can. It doesn't matter b/c you can always hide this
data. e.g
A. PRO-KING
B. PRO-QUEEN
C. ALISTAIR
D. NORMAN
E. ETC

now go to Data up in the toolbar, go to validation, then in the drop down
box select List. Click the box next to the cells that allows you to select
cells manually and highlight all the data you want to list. Then click OK.
you can change some other settings in there but that will allow you to have a
drop down list. If you can figure out how to make the arrow stay up there
always so people know there is a drop down i would love to know. Please
email me at

"oasalako1" wrote:

I am trying to have a drop box on a cell, so I can insert several names and
pick up whichever one I want

e.g
A. PRO-KING
B. PRO-QUEEN
C. ALISTAIR
D. NORMAN
E. ETC

I NEED ALL THIS TO SHOW IN A CELL AND I WILL NOW PICK THE ONE I NEED INSTEAD
OF HAVING TO TYPE THEM OVER AND OVER AGAIN.

ANY HELP, PLEASE