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!

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!

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!

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!