Saturday, October 22, 2011

How to Create a Simple Drop


1. Click on the cell in the workbook where you want your drop-down list to appear.
2. Select the 'Data' tab. From the 'Data Tools' menu, click 'Data Validation.' The Data Validation dialog will appear.
3. From the 'Settings' tab, click the 'Down Arrow' and select 'List.'
4. For a simple list, type the items in the Source box in the order you want them to appear in the drop-down, separating them by a comma. Click 'OK.'
5. At the insertion point, click the 'Down Arrow' to display the options, clicking on an option to select it.

Blogger news