Creating a List

To create a list in Excel, you can enter data on worksheet cells , just as you do on 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 can 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.

Did You Know?

You can hide the border of inactive lists . Click a cell in the list, click the Data menu, point to List, and then click Hide Border Of Inactive Lists.

You can display a total row in a list . If your list contains numbers , click the Toggle Total Row button on the List toolbar to display a row at the bottom of the list with the word "Total" in the left-most cell and an appropriate Subtotal formula in the right-most cell.