Microsoft® Office Excel® 2007 Plain & Simple

Creating a Data Table

One popular way to maintain data in Excel is by creating a table. A table describes one type of object, such as orders, sales, or contact information. Structurally, a table consists of a header row, which contains labels describing the data in each column, and data rows, which contain data about a particular instance of the table’s subject. For example, if you use a table to store your customer’s contact information, you could have a separate column for the customer’s first name, last name, street address, city, state, postal code, and telephone number. Each row in a table would contain a particular customer’s information.

Before Excel 2003, the program didn’t have a formal way of dealing with data tables. In Excel ...