Drop Down in Cell?

[Martin Schmid]

I have a spreadsheet I created a while ago. It has cells with drop down
lists... i.e., when in the cell, it shows a down-arrow/chevron to the right
of the cell. Clicking on the down arrow gives a list of items to select
from... based on the selection, other cells receive data from look-up
tables.

How did I create the drop down list in the cell? The cell has no formula,
etc... just the behavior of the drop down. I can't remember how I did this..

Please help!

Thanks
MS

 

[Harald Staff]

Hi Martin

Data > Validation. See De bra's page
http://www.contextures.com/xlDataVal01.html
on this.

 

[Chip Pearson]

Martin,

This is done with the Data Validation tool on the Data menu. Set
the "Allow" setting to List and enter a range containing the list
of valid values.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Martin Schmid]

That's it, thanks!
MS

Hi Martin

Data > Validation. See De bra's page
http://www.contextures.com/xlDataVal01.html
on this.

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Martin Schmid" <[email protected]> skrev i melding news:#[email protected]...