Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
XL97: How to Restrict Numeric Entry to Only One Cell in a Range
Article ID: 188661 - View products that this article applies to.
This article was previously published under Q188661
This article shows you how to use data validation to ensure that a number can be entered into only one cell in a range that you specify.
By using a data validation formula, you can ensure that a number can be entered into only one cell in a range that you specify. The data validation formula should look as follows
where <RANGE> is the range you want to restrict.
For example, if you want to allow a number to be entered into either cell A2 or B2, but not both, follow these steps:
For more information about data validation, click the Office Assistant, type data validation, click Search, and then click to view "Prevent entry of incorrect data in a cell."
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:
120802For additional examples of data validation, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/120802/EN-US/ )Office: How to Add/Remove a Single Office Program or Component
(http://support.microsoft.com/kb/159252/EN-US/ )XL97: Description and Examples of Data Validation
Article ID: 188661 - Last Review: October 21, 2000 - Revision: 1.0