How to restrict a cells in Excel

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

Leave a Reply

Your email address will not be published. Required fields are marked *