The pivot tables 101 article says to use the "Create List" comman.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cgnoland03 - 14 Jan 2005 22:47 GMT

I cannot locate the "Create List" command anywhere, yet in the beginning
article on pivot tables for excel 2002-2003, it says to start with a "list: A
series of rows that contains related data or a series of rows that you
designate to function as a datasheet by using the Create List command."

Reply to this Message

Debra Dalgleish - 14 Jan 2005 23:12 GMT

'Create List' is a new feature in Excel 2003. If you're using an earlier
version, you can ignore that reference. Create a table, with headings in
the first row, and data in the following rows.

There's a PivotTable intro and links on Jon Peltier's web site:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

> I cannot locate the "Create List" command anywhere, yet in the beginning
> article on pivot tables for excel 2002-2003, it says to start with a "list: A
> series of rows that contains related data or a series of rows that you
> designate to function as a datasheet by using the Create List command."

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

IanRoy - 14 Jan 2005 23:39 GMT

Hi, cgnoland03;
Data> List> Create List.
Regards,
IanRoy

Reply to this Message