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.
“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?
@faivordu, you can see written instructions on my Contextures website:
Excel Pivot Table Select
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
Very useful!
Thank you! it solved my problem! 🙂