Microsoft Office Tutorials and References
In Depth Information
Editing PivotTables
12
On the Quick Access Toolbar , click the Undo button to reverse the last change.
13
On the Design tab, in the Layout group, click Subtotals , and then click Show All
Subtotals at Bottom of Group to display subtotals in the workbook.
14
Click the Package Summary sheet tab to display the Package Summary worksheet.
15
In cell C4 , enter = , but do not press Enter.
16
Click the PivotTable sheet tab to display that worksheet.
17
Click cell K32 , and then press Enter . When you do, Excel creates the formula
=GETPIVOTDATA(“Volume”,Sheet2!$A$3,”Year”,2013) in cell C4 .
Search JabSto ::




Custom Search