How to Make Pivot Table Selections in Excel

By Stephen L. Nelson, E. C. Nelson

In Excel 2007 and Excel 2010, the Select commands appear on the PivotTable Tools Options tab when you click the drop-down arrow button to the right of the Options command button. Also, Excel 2007 and Excel 2010 use the term data rather than the term values.

At your disposal is the Analyze ribbon’s Select submenu of commands: Labels and Values, Values, Labels, Entire PivotTable, and Enable Selection. To display the Select submenu, click the drop-down arrow button to the right of the Select command button. When Excel displays the Select menu, choose the command you want.

Essentially, when you choose one of these submenu commands, Excel selects the referenced item in the table. For example, if you choose Select→Label, Excel selects all the labels in the pivot table. Similarly, choose the Select→Values command, and Excel selects all the values cells in the pivot table.

The only Select menu command that’s a little tricky is the Enable Selection command. That command tells Excel to expand your selection to include all the other similar items in the pivot table. For example, suppose that you create a pivot table that shows sales of herbal tea products for California, Oregon, and Washington over the months of the year. If you select the item that shows California sales of Amber Waves and then you choose the Enable Selection command, Excel selects the California sales of all the herbal teas: Amber Waves, Blackbear Berry, Purple Mountains, Shining Seas, and so on.