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