Drop Down Menu Title

  • Thread starter MB_HCAthleticTrainer
  • Start date
M

MB_HCAthleticTrainer

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
 
M

Mattlynn via 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
 
M

Mattlynn via 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
 
J

JBeaucaire

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.
 
C

CellShocked

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top