Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» Creating List Objects

CATEGORY: Excel Data



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.
Screenshot // Creating List Objects

Creating List Objects
Rate this tip
12 34 5
  RATING: 2.71
  VIEWS: 35259
  No comments have been submitted.


REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation