Friday, January 13, 2012

How to Create a List Box to Select Multiple Entries in Excel 2003


1. Enter the data you wish to format as a drop-down list within a single row or column. Make sure it is a single block of cells such as A2:A6.
2. Highlight the cells in your list. Click the 'Name' box next to the 'Formula' bar and enter a name for your list. Click 'Enter.'
3. Click 'Validation' from the 'Data' tab. Highlight the cells for which you created the list. Choose 'List' from the 'Validation' box. Type a '=' sign before the name of your list within the 'Source' box and click 'OK.'

Blogger news