1. Home
  2. Computing & Technology
  3. Spreadsheets

Create a Data List in Excel 2003

By , About.com Guide

5 of 8

Columns are Fields

Field names in an Excel table

Field names in an Excel table

� Ted French

Columns are Fields

While rows in the table are referred to as records, the columns are known as fields. Each column needs a heading to identify the data it contains. These headings are called field names.

  • Field names are used to ensure that the data for each record is entered in the same sequence.

  • Make sure that all the data in a column is entered using the same format. If you start entering numbers as digits (such as 10 or 20) keep it up. Don't change part way through and begin entering numbers as words (such as ten or twenty). Be consistent.

  • Leave no blank columns in the table.

  • To create a list, a table needs to be at least two columns wide.
Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. 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 Field Names

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

All rights reserved.