If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
The pivot tables 101 article says to use the "Create List" comman.
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." |
#2
|
|||
|
|||
'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 cgnoland03 wrote: 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." -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Hi, cgnoland03;
Data List Create List. Regards, IanRoy "cgnoland03" wrote: 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." |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
dumping list of all tables and all fields | Todd F. | General Discussion | 2 | December 3rd, 2004 06:13 PM |
Pivot Table option, display as data list, repeating items down | carl.fields | Worksheet Functions | 4 | September 17th, 2004 07:57 PM |
Office XP | Ed Lester | Setup, Installing & Configuration | 1 | May 27th, 2004 09:30 AM |
Pivot Table from data table (not data LIST) | absolin | Charts and Charting | 2 | January 2nd, 2004 09:30 PM |
Pivot Table from data table (not data LIST) | Tushar Mehta | Charts and Charting | 0 | December 13th, 2003 05:23 PM |