• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 25. Working with Lists and Databases > Creating a List on a Worksheet

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 that match criteria that you specify. For complex lists, Excel can automatically create outlines that let you summarize and subtotal groups of records. Large, complex lists are a perfect starting point for PivotTable and PivotChart reports, which let you drag fields on a layout page to perform complex data-analysis tasks without having to construct a single formula.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint