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

Chapter 28. 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 equivalent to a database field, and each row is the same as a record of data; headings in the top row represent the names of the fields. Within each column, 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.

Excel 2003 includes several usability improvements designed to make it easier to create and manage lists:



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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