See how you can enable pivot table selection, then select just the pivot table labels, or select both the labels and the data. Select the entire pivot table, and move it to a different location
In this pivot table video tutorial, you'll see how to enable selection and use the Selection Arrow. There are written steps, and more pivot table selection tips, below the video
You can use the Selection Arrow to highlight specific sections of an Excel Pivot Table. Before the Selection Arrow can work correctly, you might have to turn on the Enable Selection feature.
To turn on Enable Selection:
Once the Enable Selection feature has been turned on, you can use the Selection Arrow to select the entire Pivot Table.
To select the entire pivot table, including the report filters:
In some Pivot Table report layouts, the Select All arrow might not appear when you point to the top left cell. In that case, you can use the Ribbon commands.
To select the entire pivot table, including the report filters:
Instead of manually selecting a large pivot table and moving it, you can use a built-in command to move a pivot table. Watch this short video to see the steps, and the written instructions are below the video.
If you need to move a pivot table, after creating it, there is a Ribbon command that will automatically select the entire pivot table, and move it to a new location.
To move a pivot table:
Once the Enable Selection feature has been turned on, you can use the Selection Arrow to select specific sections of an Excel Pivot Table.
To select only the Row Labels:
To select only the Column Labels:
To select all the Labels:
After you have selected the Row or Column labels, you can extend the selection, to include the Labels and their related values.
To select the Labels and Values:
You can download the zipped Pivot Table Selection sample file for this tutorial. The Excel workbook is in xlsx format, and does not contain any macros.
Last updated: July 12, 2021 11:41 AM