Selecting rows, columns and cells in a pivot table

You can select an entire row or column or a specified set of data and label cells.

To select multiple cells:

1. Activate the pivot table.
2. Select the first cell and then use Shift+click to include a contiguous group of cells. Use Ctrl+click to select non-contiguous cells one at a time.

   To select an entire row or column:

3. Activate the pivot table.
4. Click a row or column label.
5. Click the row or column label again.

   Note: This method is not available for legacy tables.

   or

6. Click a row or column label.
7. From the menus, choose:

   Edit > Select > Data and Label Cells

   or

8. Right-click the category label for the row or column.
9. From the menu, choose:

Select > Data and Label Cells