Tip Printed from ExcelTip.com

---

Creating List Objects


New in Excel 2003!

What are the advantages of creating a List Object?
You can Sort, Print, create Charts, Insert rows/columns, Delete rows/columns, add Toggle Total Row, import data to XML and publish the List to a Share Point site from the new List toolbar.

What is the advantage of creating a Chart from a List Object?
When adding data to the List Object, the Chart automatically expands/updates itself.

To create a List Object using Excel 2003:
Select a cell in the List area and press Ctrl+L.
OR
From the Data menu, select List, and then Create List.