Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
[1] in the title menu | Excel Discussion (Misc queries) | |||
[1] in the title menu | Excel Discussion (Misc queries) | |||
Title in dropdown menu to stay | Excel Discussion (Misc queries) |