You cannot move or modify part of a PivotTable or insert cells within a PivotTable. If you want to insert cells on the worksheet, ...

You cannot move or modify part of a PivotTable or insert cells within a PivotTable.If you want to insert cells on the worksheet, drag the PivotTable out of the way. To move or insert data in a PivotTable, you can do one of the following:

• Use the PivotTable Wizard to add fields to the PivotTable.
• Hide or group items in a row or column field.
• Edit the source data.
English
English (United States)
Deutsch (Deutschland)
German (Germany)
Español (España)
Spanish (Spain)
Français (France)
French (France)
italiano
Italian
日本語
Japanese