Excel Tip-How To Quickly Select All Or Just Parts Of Your Pivot Table


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,

  1. Select a cell in the Pivot Table
  2. On the Pivot Table Tab- selection Options
  3. In the Actions group -Click Select
  4. 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:

  1. Point to the top border of the top left cell, in the body of the pivot table.
  2. 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

  1. On the Pivot Table Tab- selection Options
  2. In the Actions group -Click Select
  3. 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

 


Learn Excel Dashboard Course

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts