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:
- Activate the pivot table.
- 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:
- Activate the pivot table.
- Click a row or column label.
- Click the row or column label again.
Note: This method is not available for legacy tables.
or
- Click a row or column label.
- From the menus, choose:
or
- Right-click the category label for the row or column.
- From the menu, choose: