Excel's data validation tool lets you restrict a cell's inputs so that they meet certain criteria. This helps to prevent errors. As you can see, this will prevent any errors from occurring.
office.com/setup enter office product key - You can select which Error Alert message you want to see if you add a drop-down list to a worksheet or any other type data validation. You cannot enter invalid data if the default setting is Stop. You will see an error message with buttons to Retry, Cancel, and Help.
