Data validation lets you create custom drop-down lists in your Microsoft Excel spreadsheet. The drop-down lists keep you in control of the data that is entered on your spreadsheet. The information displayed in the drop-down list is specified by the data source in the Data Validation settings. Format the drop-down lists by selecting the displayed information, input messages and error alerts. After confirming the data validation setup, the drop-down list will appear immediately. Writer Bio
