Friday, December 21, 2012

How to Create a Drop


1. Open Excel 2007 and click a blank cell in the workbook. Select the 'Data' tab and select 'Data Validation.' A drop-down list appears. Click 'Data Validation.' On the 'Setting' tab, change the Allow field to 'List.' In the source field, type 'yes,no,maybe.'
2. Click the 'Input Message' tab. Click 'Show input message when the cell is selected.' Add a title for your input message in the 'Title' field. Add a custom input message in the 'Input Message' notes field.
3. Click the 'Error Message' tab. Click 'Show error message when invalid data is entered.' Add a title for your error message in the 'Title' field. Add a custom input message in the 'Error Message' notes field. Select a style for your error message in the 'Style' drop-down list. Click 'OK.'
4. Click the cell where you started the data validation process. Notice the drop-down list that appears. You also will see the input message.

Blogger news