Wednesday, January 26, 2011

How to Create a List Box in Excel 2003


1. Launch Excel 2003 and access the 'Forms' toolbar. Click the 'View' menu, highlight the 'Toolbars' option and select the 'Forms' listing.
2. Type the responses that you want to appear in the list box into individual, sequential cells. For example, type 'Spring,' 'Summer,' 'Fall' and 'Winter' into separate cells 'A:1' though 'A:4.' Put this information on a separate worksheet within the workbook if you do not want users to see them outside of the list box.
3. Click the 'List Box' button on the Forms toolbar. Click once in the area of the worksheet to which you want to add the list box. Drag to a desired size while holding down the mouse button. Right-click once on the list box and select the 'Format' option, which will open a new window.
4. Click the 'Control' tab on the 'Format Control' window. Click once in the 'Input Range' field. Highlight the responses you entered in Step 2. Click the 'OK' button to complete the process of adding a list box in Excel 2003.

Blogger news