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

Creating a List

To create a list in Excel, you can enter data on worksheet cells, just as you do any other worksheet data, but the placement of the field names and list range must follow these rules: (1) Enter field names in a single row that is the first row in the list (2) Enter each record in a single row (3) Do not include any blank rows within the list range (4) Do not use more than one worksheet for a single list range. You can enter data directly in the list or in a data form, a dialog box in which you can view, change, add, or delete records in a list. Don't worry about entering records in any particular order; Excel tools organize an existing list alphabetically, by date, or in almost any order you can imagine.

Create a List

Open a blank worksheet, or use a worksheet that has enough empty columns and rows for your list.

Enter a label for each field in adjacent columns across the first row of the list.

Enter field information for each record in its own row; start with the row directly below the field names.

Select the range of cells for the list.

Click the Data menu, point to List, and then click Create List.

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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