Microsoft Office Tutorials and References
In Depth Information
If the PivotTable Field List task pane isn’t visible, you can display it by clicking any cell in
the PivotTable to display the PivotTable Tools contextual tabs. On the Options contextual
tab, in the Show/Hide group, click Field List.
To assign a field, or column of data, to an area of the PivotTable, drag the field header
from the Choose Fields To Add To Report area at the top of the PivotTable Field List task
pane to the Drag Fields Between Areas Below area at the bottom of the task pane. For
example, if you drag the Volume field header to the Values area, the PivotTable displays
the total of all entries in the Volume column.
Search JabSto ::

Custom Search