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

Part VI: Managing Lists or Databases > Entering Data in a List or Database

Chapter 35. Entering Data in a List or Database

  • Identify the fields and the database to be used in Excel

    You identify the columns that will act as your fields by entering the field names in the first rows of a list.

  • Enter data in a form using the Data, Form command

    You can use the Data, Form command to open Excel's automatic data form to enter your data.

  • Enter data directly in cells on a worksheet

    Entering the data directly into the worksheet requires an understanding of how the list features work to take advantage of the filtering and sorting capabilities.

  • Enter data using data-entry shortcut keys

    When you are entering information directly into the worksheet, you can increase your efficiency by taking advantage of the data-entry shortcut keys.

  • Format a list using the AutoFormat command

    The AutoFormat command allows you to format your data with built-in styles.

Although Excel is primarily a spreadsheet, it has list management capabilities that can help you analyze stock market trends, track client names and addresses, monitor expense account data, and store sales figures. The combination of list functions, powerful worksheet analysis capabilities, and charting capabilities makes Excel an excellent tool for business analysis and management systems.


Excel uses the term list to refer to related information stored in rows and columns. If you are familiar with previous versions of Excel or with other software, you may be more familiar with the term database.

This and the following chapters describe how to build and use a list that resides in an Excel worksheet. A list is like an automated card file system that enables you to find information quickly and then edit, sort, extract, print, or analyze it. In the most simple form of an Excel list, you only need a set of information topped by a row of headings to use some of Excel's list management features.

In this chapter, you learn how to build a list and how to enter information. If you want to find and edit information in a data-entry form, you will find the discussion on the automatic data form interesting. If you want to enter information directly into a list on the worksheet, you will prefer the other methods.



Not a subscriber?

Start A Free Trial

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