1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Create a Data List in Excel 2003


6 of 8

Creating the List
Using the Create List dialog box in Excel

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.

©2014 About.com. All rights reserved.