How to Use the Drop

1. Open Excel 2007 and select a workbook. Press 'Control' and 'O.' Browse your computer for the Excel workbook. Click the workbook and click 'Open.' The workbook opens.
2. Select a cell or group of cells to apply the data validation. Select the 'Data' tab and click 'Data Validation.' Select 'Data Validation' from the drop-down list. On the 'Settings' tab, select 'List' from the 'Allow' drop down criteria. Type 'Yes,No,Maybe' in the 'Source' field.
3. Click the 'Input Message' tab. Check the option for 'Show Input Message When The Cell Is Selected.' Type the title of your input message in the 'Title Field.' Type a custom message for the input message in the 'Input Message' field.
4. Click the 'Error Alert' tab. Check the option for 'Show Error Alert After Invalid Data Is Entered.' Type the title of your error alert in the 'Title Field.' Type a custom message for the error message in the 'Error Alert' field. Click 'OK.'
5. Click a cell and notice the appearance of the drop-down list. Data validation has added drop-down boxes in Excel.