Select OK if the data in the Create List dialog is correct otherwise, make your changes and click OK. Excel makes a guess as to the range containing the data and gives you the option of specifying whether or not your list has headers.īy default Excel lists have the Filter option enabled although this can be disabled, if desired Click somewhere inside the data area and choose Data > List > Create List. Open a worksheet containing a table of data. See for yourself how easy it is to work with lists in Excel 2003. Lists in Excel 2003 also have automatic totals built into them so that you can select the calculation to apply to a list column and Excel will automatically create the formula for you. This lets you add or delete a row in one list and the other list will remain unaffected by the changes. In addition, you can position lists side-by-side in the same worksheet, and they act independently of each other.

Using this tool you can define an area of a worksheet as a list, which gives the area special properties such as an insert row that you can click to insert a new data row into the list. List management tasks received a boost with the new List tool in Excel 2003. Use the Data > List option to convert data in a worksheet into an Excel 2003 list

How to consolidate data in excel 2003