O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required