Special Edition Using Microsoft® Office XP

Creating a List on a Worksheet

Excel's row-and-column structure makes it an ideal tool for organizing related information into a list. On an Excel worksheet, a list is a group of consecutive rows of related data. Conceptually, an Excel list is identical to a table in Access (or any other database management program). Each column within a list is a field, and each row is a record of data; headings in the top row represent the names of the fields. Within each field, you can enter text, numbers, dates, formulas, or hyperlinks. Excel does not impose any additional restrictions on the type of data that you can enter in a list.

You can sort list data in nearly any order, search for a specific bit of information, or use filters to find groups of data ...