Monday, June 20, 2011

How to Use a Drop Down Box in Excel 2003


1. Open Excel 2003 and highlight a group of cells. Select 'Data' on the menu bar and select 'Validation.' In the validation criteria tab, change the 'Allow drop down list' to 'List.' In the 'Source' list, type 'Apples, Bananas,Grapes.' Click 'OK.'
2. Click on one of the highlighted cells. Notice the drop down list.
3. Click the drop down list. Select one of the choices in the list.

Blogger news