How can I create a list in Excel 2002?

[Guest]

I'm taking an Excel class, which uses a text for Excel 2003. The Excel
version I use is 2002, both at work and at home. The assignment I need to do
now requires steps: Data--Lists--Create Lists, however, 2002 does not have
"Lists" as an option under "Data". Is there any different way to create a
list in 2002, or must I absolutely upgrade? thanks..

 

[Debra Dalgleish]

There's information on the Microsoft site that describes the new List
features:

http://office.microsoft.com/en-ca/assistance/HA010982731033.aspx

You can probably complete most of the assignment with a regular table in
Excel 2002. Use Data>Filter>AutoFilter to create the dropdown lists at
the top of the table.

If you filter the list, then use the AutoSum button to create a total,
it will automatically create a SUBTOTAL formula, just as Excel 2003 does
in the list's Total row.

 

[Dana DeLouis]

Just to add. One can use the menu item... Data | Form to help with adding
information to your table while still in AutoFilter mode. However, a basic
Data Form will not shift other data down if required. However, a Data Form
within a List Object in Excel 2003 will Shift data down.