Excel 2003 Step by Step Database Tutorial

Creating the List

Using the Create List dialog box in Excel

© Ted French

Create the list

Note: For help on these steps, refer to the image above.

Once the data has been entered into the table, it can be converted to a list. To do so:

1. Drag select cells A3 to E13 in the spreadsheet.
   
   
2. Click on Data > List > Create List from the menu to open the Create List dialog box.
   
   
3. While the dialog box is open, cells A3 to E13 on the worksheet should be surrounded by the marching ants.
   
   
4. If the marching ants surround the correct range of cells, click Ok in the Create List dialog box.
   
   
5. If the marching ants do not surround the correct range of cells, drag select the correct range in the spreadsheet and then click Ok in the Create List dialog box.
   
   
6. The table should be surrounded by a dark border and have drop down arrows added beside each field name.

Return to Index page

• Excel Database Overview
• Creating Tables and Lists
• Entering Data Correctly
• Rows are Records
• Columns are Fields
• Creating the List
• Using the Database Tools
• Expanding the Database
• Formatting the Database