| 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. | -
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. | |