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

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

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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200910/1

You can actually put the word SPORT into the cells before applying the Data
Validation for the drop-down list. When they click the cell, SPORT will be
the current value, but it will not be a value IN the list.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"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

On Sun, 18 Oct 2009 01:50:01 -0700, JBeaucaire
wrote:

You can actually put the word SPORT into the cells before applying the Data
Validation for the drop-down list. When they click the cell, SPORT will be
the current value, but it will not be a value IN the list.


You can comment the dropdown list so that hovering over the cell pops
up the note.

You can also comment the cell itself.

One pops up the comment when the cell is selected, the other, when
hovered over. You want the hover version as cell selection puts up the
drop down list.