Excel: Problem Altering Combo Box List

  • Thread starter Thread starter AlmoAtAcclaim
  • Start date Start date
A

AlmoAtAcclaim

Hi!

I've attached an xls with a drop-down box in it, and nothing else. It
was created a year ago by someone who's left the company.

Two things:

How do you create a combo box like this? I mean, it's embedded in a
cell, not floating above the sheet. Also, you can't right click it and
get either Properties or Format Control.

How can I change the list of things you get when you click the arrow?

Thanks,
AlmoAtAcclaim

Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=397095
 
It's Data Validation (DV)

Select the cell, then click Data > Validation
(you'll see a DV dialog box at Settings tab: with "List" under "Allow",
and some stuff under "Source" which appears in the drop list.)

To learn about data validation,
here's the oft quoted link to MVP Debra D's nice coverage:
http://www.contextures.com/xlDataVal01.html
 
Back
Top