The data in the fields you drag to the ROW and COLUMN areas become the row and column labels of your PivotTable. When you ...

The data in the fields you drag to the ROW and COLUMN areas become the row and column labels of your PivotTable. When you drag a field to the PAGE area, you create a drop-down list that you can use to filter for specific values in the field.

If you want to change the layout after you finish creating the PivotTable, you can return to this step easily. Just click PivotTable Report on the Data menu.
English
English (United States)
Deutsch (Deutschland)
German (Germany)
Español (España)
Spanish (Spain)
Français (France)
French (France)
italiano
Italian
日本語
Japanese