Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'd like to setup a column in excel with several fixed possible values (like 'in-progress', 'done', 'canceled').

I'd like to set it up so the only possible values in these column are from the fixed list, and it would be easy to pick one of these items whenever I try to edit a cell in this column (a drop-down box would be ideal). How can I do that?

share|improve this question

2 Answers 2

up vote 9 down vote accepted

Piece of cake.

1) Enter your list of the fixed values. (These have to be in the same sheet as the cell you want to restrict)

2) Click on the cell you want to restrict. Select "validation" from the Excel "Data" pull down menu

3) In the pull down on the "Settings" tab select "List"

4) click In the box labeled "Source" then select the cells that contain the values set up in step 1)

5) Click OK and you are done.

You can do this for any number of cells

You will see a pull down icon next to the restricted cell(s). Click on it to choose only values in the list. Excel will not allow any other value in this cell.

Look around in the Validation dialog box and you will see you can tweak how this works.

share|improve this answer

Rather than selecting a buch of cells with the values in them you can write the values in as a semicolon seperated list in the source box instead.

share|improve this answer
    
Thanks for the info, very useful. –  Matthieu Napoli Oct 13 '11 at 7:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.