If you use Pivot Tables regularly and you either move them around, select parts of them or indeed all of them, then here is a really quick method for selecting areas of your Pivot with ease…with the Pivot Table Enable Selection options in Excel.
First of all you need to ensure that the Enable Section is turned ON. To turn it on,
- Select a cell in the Pivot Table
- On the Pivot Table Tab- selection Options
- In the Actions group -Click Select
- Check if Enable is ON or Off
This is ON–
This if OFF-
The difference is the small coloured square around the Enable Selection option. Once the enable selection is turned on you can use the Selection Arrow to select the entire Pivot Table.
To select the entire pivot table, including the report filters:
- 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.
Or, you can use the Ribbon command by selecting any cell in your Pivot Table and then
- On the Pivot Table Tab- selection Options
- In the Actions group -Click Select
- Choose Entire Pivot Table
You can then repeat the same process, for selecting the other options available which are to select……
Values
Labels and Values
Labels