Create an Excel list

  1. Highlight the range of data that you want make into a list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.).

 Note   You can also select the range of cells to be specified as a list by selecting the range of cells from the Create List dialog box.

  1. On the Data menu, point to List, and then click Create List.
  2. If the selected data has headers, select the My list has headers check box and click OK.

The selected range of data is highlighted by the list indicator, and the most common list related functionality is made available on the List toolbar.

 Note   If you don't see the List toolbar, on the View menu point to Toolbars, and then click Toolbars.

After the list has been created, it will be identified by a blue border. In addition, AutoFilter drop-downs will be automatically enabled for each column in the list and the insert row will be added as the last row or the list. If you choose to add a total row by clicking Toggle Total Row  Button image on the List toolbar, a total row will be displayed under the insert row.

When you select a cell, row, or column outside of the list, the list becomes inactive. An inactive list is surrounded by a blue border and does not display the insert row or AutoFilter drop-downs.

 Note   The border will not be displayed if you clicked Hide Border of Inactive Lists on the List menu.

Applies to:
Excel 2003