Contextures

Pivot Table Selections

How to select pivot table labels, or labels and data. Turn on a setting to enable selection. Select the entire pivot table, and move it to a different location

Enable Selection in a Pivot Table

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:

  1. Select a cell in the pivot table, and on the Ribbon, click the Options tab.
  2. In the Actions group, click Select
  3. Check to see if Enable Selection is ON or OFF, as shown in the screen shot below.

    enable selection on

  4. If Enable Selection is OFF, click it to activate the feature.
  5. If Enable Selection is ON, click the worksheet, to close the menu without making a selection. go to top

Select the Entire Pivot Table

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:

  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.

    pivot selection row label

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:

  1. Select a cell in the pivot table, and on the Ribbon, click the Options tab.
  2. In the Actions group, click Select
  3. Click Entire PivotTable.

pivot selection row label

Video: Move a Pivot Table

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.

Move a Pivot Table

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:

  1. Select any cell in the pivot table
  2. On the Excel Ribbon, under Pivot Table Tools, click the Options tab
  3. In the Actions group, click the Move PivotTable command
  4. move pivot table

  5. In the Move dialog box, select New Worksheet, or select a location on an existing sheet.
  6. move pivot table

  7. Click OK

Select Labels in 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:

  1. Point to the top border of a Row Label heading
  2. When the pointer changes to a thick black arrow, click, to select the row labels for that field.

    pivot selection row label

To select only the Column Labels:

  1. Point to the top border of a Column Label heading
  2. When the pointer changes to a thick black arrow, click, to select the column labels for that field.

    pivot selection column label

To select all the Labels:

  1. Point to the top border of a Column Label heading
  2. When the pointer changes to a thick black arrow, click, to select the column labels for that field.

    pivot selection column label

Select Labels and Values in a Pivot Table

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:

  1. Select Row or Column labels, as described in the previous section.
  2. On the Excel Ribbon, click the Options tab.
  3. In the Actions group, click Select
  4. Click Labels and Values

    pivot selection labels and values

Watch the Pivot Table Selection Video

In this pivot table video tutorial, you'll see how to enable selection and use the Selection Arrow.

More Tutorials

Excel Pivot Table Report Filters

FAQs - Pivot Tables

Pivot Table Introduction

Running Totals

Summary Functions

Clear Old Items in Pivot Table

Search Contextures Sites

 

Excel Tools Add-in

Free Pivot Table Tools

 

Pivot Power Premium

 

Excel Data Entry Popup List

 

 

 

Excel UserForms for Data Entry

 

Last updated: September 22, 2016 7:12 PM
Contextures RSS Feed