In Excel 2003, a list is a specially designated range of numbers. This special range of numbers, has added functionality that other cell ranges do not have. You can have more than one list in a workbook or worksheet if you want, and lists can be as large or small as the amount of data you want to work with.

 

Normally a list is made from adjacent columns of data, with a unique label or heading for each column. Each row in the list should have entries organized according to the column headings. Remember, that Excel has a lot more rows down, than columns across. This design is well suited for data organised in long adjacent columns, like a list. You can make a list with empty rows or columns if required, but this is not recommended. You should keep your list data adjacent in a block to take advantage of all of Excel’s list features.

 

 

 

 

 

 

 

Some Excel features, like filters, pivot tables, and data forms, will not work correctly if the data is not blocked together in adjacent columns as a list.