Selecting Sections of an Excel Pivot Table

When working with a pivot table, you might want to select a specific section, such as the subtotals, or a set of labels. In this short video I use the Selection Arrow to select specific sections of an Excel Pivot Table.

I also show you how to turn on the Enable Selection feature, if you can’t see the Selection Arrow when working with pivot tables on your computer.

For more information on pivot tables, see the Pivot Table Topics on my Contextures web site.

4 thoughts on “Selecting Sections of an Excel Pivot Table”

  1. “In this short video I use the Selection Arrow to select specific sections of an Excel Pivot Table.”
    Where I have been able to read about this?

  2. Hi!
    A. “FANTASTIC” SITE…has been VERY helpful since I discovered it, 2 months ago..
    B. re: losing formatting in PV table…
    is the >>enable selection<< ON when the icon is small, or, when it is BIG…:-)?
    Thanks!
    Les

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.