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.
Select a cell in the pivot table, and on the Ribbon, click the Options tab.
Check to see if Enable Selection is ON or OFF, as shown in the screen shot below.
If Enable Selection is OFF, click it to activate the feature.
If Enable Selection is ON, click the worksheet, to close the menu without making a selection.
Once the Enable Selection feature has been turned on, you can use the Selection Arrow to select the entire Pivot Table.
Point to the top border of the top left cell, in the body of the pivot table.
When the pointer changes to a thick black arrow, click, to select the entire pivot table.
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.
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.
In the Move dialog box, select New Worksheet, or select a location on an existing sheet.
Once the Enable Selection feature has been turned on, you can use the Selection Arrow to select specific sections of an Excel Pivot Table.
When the pointer changes to a thick black arrow, click, to select the row labels for that field.
When the pointer changes to a thick black arrow, click, to select the column labels for that field.
After you have selected the Row or Column labels, you can extend the selection, to include the Labels and their related values.
Select Row or Column labels, as described in the previous section.
On the Excel Ribbon, click the Options tab.
In this pivot table video tutorial, you'll see how to enable selection and use the Selection Arrow.