1. Computing

Create a Data List in Excel 2003

By , About.com Guide

7 of 8

If the List Range is Incorrect
Creating lists in Excel

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.

©2013 About.com. All rights reserved.