You could use sport as one of the options in the drop down list, and slect
them all to that sport

In the range, you would have
SPORT
FOOTBALL.
RUGBY
TENNIS
ETC
ETC
ETC
Set the boxed to SPORtto start with


MB_HCAthleticTrainer wrote:
Is there a way to title my drop-down menu in the same cell?
Ex: I have a spreadsheet for morning treatment appointments. The times are
listed in column A with 5 appointment openings for each time in row 1 (5
appointments open at 7:00, etc). I want a patient to be able to type their
name in B2 and select the sport they play in B3. I have the drop-down menu
in B3 and typed in "name" in B2 so they know to put their name there. Is
there a way to title the drop-down menu as SPORT so they know to select the
menu and choose their sport (I want the actual title in cell B3)?

I want it to look like this with the drop-down menu where is says SPORT:
Appt 1 Appt 2 Appt 3 Appt 4 Appt 5
6:00 Name Name Name Name Name
SPORT SPORT SPORT SPORT SPORT
7:00 Name Name Name Name Name
SPORT SPORT SPORT SPORT SPORT
8:00 Name Name Name Name Name
SPORT SPORT SPORT SPORT SPORT
9:00 Name Name Name Name Name
SPORT SPORT SPORT SPORT SPORT

--
Matt Lynn

Message posted via http://www.officekb.com