How do i insert drop down menu using multiple cells.

[Guest]

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!

 

[Guest]

You'll need to use data validation and maybe a Worksheet_Change event.

That should get you started.

HTH,
Barb Reinhardt

 

[Guest]

Try Data validation and Conditional Formatting

 

[Guest]

Have you tried to use the Data>AutoFilter option? If you click on the top of
the Column (say A for example) the click on Data>AutoFilter 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 Data>AutoFilter it will put
a drop down arrow on top of each column.