Home |
Search |
Today's Posts |
#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." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
How to change default page setup for pivot tables? | Excel Discussion (Misc queries) | |||
How do you create a drop down list? | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |