Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want users to enter only 1 or 0 in a cell column in Excel 2007. Users should not be able to enter anything else than 1 or 0. How can I do this in Excel?

share|improve this question

This page has instructions on how to do it, in detail. I will quote a section though:

Data Validation dialog

share|improve this answer
Spot On! Thanks soandos for your answer – Mark Kevus Aug 18 '11 at 17:04

Lance: You can restrict users entry using data validation. To create your data validation, follow the steps below:

  • Use Sheet2 in the workbook to create the name range for the data validation
  • In column A, row A1, make sure to enter a heading. For example Enter_Number
  • In Sheet 1, make sure you type your heading in A1
  • Highlight A2:A10, click Data on the menu option, click Data Validation, select List from the dropdown option
  • In the Source filed, do = and enter your heading title in Sheet2. For example, =Number You can use the F3 in the Source field to choose the heading you entered in Sheet 2 Screen Shot Detailing Data Validation Steps enter image description here

enter image description here

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .