| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i insert drop down menu using multiple cells.
In an excel sheet i want to insert a drop down menu at the top of the sheet
with the alphabet in it, so, when i click on a letter in the drop down menu it will hi-light the same letter that's in the list on the sheet. How do i do it? Any help would be great! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i insert drop down menu using multiple cells.
You'll need to use data validation and maybe a Worksheet_Change event.
That should get you started. HTH, Barb Reinhardt "wolf24359" wrote: In an excel sheet i want to insert a drop down menu at the top of the sheet with the alphabet in it, so, when i click on a letter in the drop down menu it will hi-light the same letter that's in the list on the sheet. How do i do it? Any help would be great! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i insert drop down menu using multiple cells.
Try Data validation and Conditional Formatting
"wolf24359" wrote: In an excel sheet i want to insert a drop down menu at the top of the sheet with the alphabet in it, so, when i click on a letter in the drop down menu it will hi-light the same letter that's in the list on the sheet. How do i do it? Any help would be great! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i insert drop down menu using multiple cells.
Have you tried to use the DataAutoFilter option? If you click on the top of
the Column (say A for example) the click on DataAutoFilter it will give you a drop down list of everything in that column so you can select your information. If you click on the number of the row then use DataAutoFilter it will put a drop down arrow on top of each column. "Teethless mama" wrote: Try Data validation and Conditional Formatting "wolf24359" wrote: In an excel sheet i want to insert a drop down menu at the top of the sheet with the alphabet in it, so, when i click on a letter in the drop down menu it will hi-light the same letter that's in the list on the sheet. How do i do it? Any help would be great! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i choose multiple options in a drop down menu in excel? | Excel Discussion (Misc queries) | |||
| Drop Down Menu and multiple results | Excel Discussion (Misc queries) | |||
| I need to insert a drop down menu in a cell? | Excel Worksheet Functions | |||
| Multiple selections in a drop down menu | Excel Worksheet Functions | |||
| How do u insert a drop down menu in a Excel | Excel Worksheet Functions | |||
Linear Mode
