1. Home
  2. Computing & Technology
  3. Spreadsheets

Create a Data List in Excel 2003

By Ted French, About.com

4 of 8

Rows are Records

A data record in an Excel table

A data record in an Excel table

� Ted French

Rows are Records

As mentioned, rows of data, are known as records. When entering records keep these guidelines in mind:

  • Leave no blank rows in the table being created, not even between the headings and the first row of data.

  • A record can contain data about only one specific item.

  • A record must also contain ALL the data in the list about that item. There can't be information about an item in more than one row.

  • To create a list, a table of data needs to contain at least two data records.
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 - Creating Data Records

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

All rights reserved.