Drop-down in Excel

  • Thread starter Thread starter Alain Dekker
  • Start date Start date
A

Alain Dekker

Hi,

I saw an Excel spreadsheet where someone had a combo (drop-down) in it. When
that cell was selected, an arrow appeared alongside the cell and there with
several items in a list that appeared. You could only select one of the
items from the list, and not type in a value.

Really cool!

However, while I can copy the cell to my own Excel sheet, I don't know how
to set one up with my own selections.

Please help.
Thanks,
Alain
 
Thanks, that worked!

The Excel help was absolutely rubbish here, I have to say. I got dozens of
irrelevant answers no matter what I tried.

Thanks Andy.
Alain
 
Alain

What version of Excel?

With Excel 2002 and 97 I type "drop-down"(no quotes) into the answer wizard
and one of the returns is "enter data in a cell from a list you specify".
Explains how to use Data Validation Lists.

Gord Dibben Excel MVP
 
Back
Top