1. Home
  2. Computing & Technology
  3. Spreadsheets

Create a Data List in Excel 2003

By Ted French, About.com

8 of 8

The List

Data tools in an Excel list

Data tools in an Excel list

� Ted French

The List

Once created,

  • the list will have a dark border around it.

  • There will be down-pointing arrows beside each field name that open drop down menus when clicked on.

  • The drop down menus contain options for sorting the list by any of the field names and for searching the list for records that match certain criteria.

  • A blank row containing an asterisk is added to the bottom of the list. Additional data can be added to the list using this new row.
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. How to Create Lists in Excel - How to Use Excel Data Tools - Sorting a List

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

All rights reserved.