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!