How to restrict a cells in Excel
Posted by admin on Oct 6, 2006 in programming |
Microsoft Office Assistance: Prevent invalid data entry in a worksheet
Explains how to limit an Excel cell to:
- Items from a list
- whole number within limits
- decimal number within limits
- date within a timeframe
- time within a timeframe
- text of a specified length
- calculate the limit based upon another cell
- use a formal to calculate what is allowed
