If Excel data is on different sheets, you can create a pivot table from multiple sheets, by using multiple consolidation ranges. It's better if the data is all on one sheet, but if you don't have that option, multiple consolidation ranges will pull all the data into one pivot table.
如果Excel数据在不同的工作表上,则可以使用多个合并范围从多个工作表创建数据透视表。 最好将数据全部放在一张纸上,但是如果没有该选项,则多个合并范围会将所有数据拉入一个数据透视表。
如何开始 (How to Get Started)
In Excel 2003 you can open the PivotTable and PivotChart wizard by choosing Data | PivotTable and PivotChart Report. There's no equivalent command on the Ribbon in Excel 2007, but you can press Alt+D, then type P to open the wizard.
在Excel 2003中,可以通过选择“数据” |“数据透视表”来打开“数据透视表”和“数据透视图”向导。 数据透视表和数据透视图报表。 Excel 2007中的功能区上没有等效的命令,但是可以按Alt + D,然后键入P以打开向导。