Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets

How to Create Lists in Excel

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

Spreadsheets

  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.