LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Drop Down Menu Title

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop dwn menu. Formula to count selection frm menu in anoth cell? ggoldber Excel Worksheet Functions 1 June 4th 08 02:21 PM
filter dropdown menu so 2nd drop menu is customized menugal Excel Worksheet Functions 1 September 4th 07 05:25 PM
[1] in the title menu naitco Excel Discussion (Misc queries) 3 April 27th 06 01:25 PM
[1] in the title menu naitco Excel Discussion (Misc queries) 3 January 25th 06 12:36 PM
Title in dropdown menu to stay Jon Excel Discussion (Misc queries) 2 March 23rd 05 05:24 PM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"