Create a Data List in Excel 2003

Creating the List

Using the Create List dialog box in Excel

� Ted French

Create the list

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

1. Select any one cell in the table.
   
   
2. Choose List > Create List from the menu to open the Create List dialog box.
   
   
3. The dialog box shows the range of cells to be included in the list. If the table was created properly, Excel will usually select the correct range.
   
   
4. If the range selection is correct, click OK.

• Data Management in Excel
• Creating Tables and Lists
• Entering Data Correctly
• Rows are Records
• Columns are Fields
• Creating the List
• If the List Range is Incorrect
• The List