View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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!