Create a Data List in Excel 2003

If the List Range is Incorrect

Creating lists in Excel

� Ted French

The list range is incorrect

If, by some chance, the range shown in the Create List dialog box is incorrect you will need to reselect the range of cells to use in the list.

To do so:

1. Click on the return button in the Create List dialog box to return to the worksheet.
   
   
2. The Create List dialog box shrinks to a small box and the current range of cells can be seen on the worksheet surrounded by the marching ants.
   
   
3. Drag select with the mouse to select the correct range of cells.
   
   
4. Click on the return button in the small Create List dialog box to return to the normal-sized one.
   
   
5. Click OK to finish the list.

• 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