1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2003 Step by Step Database Tutorial

By Ted French, About.com

6 of 9

Creating the List

Using the Create List dialog box in Excel

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

Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Data Management in Excel
  5. Create Excel Database- How to Create an Excel Database - Creating the List

©2009 About.com, a part of The New York Times Company.

All rights reserved.