-
Open a datasheet or form in PivotTable view.
-
Do one of the following:
-
To select a single cell, click it. To select a group of cells, click and drag the mouse pointer until all the cells you want are selected.
Select a row, column, filter, detail, or total field
-
Click the field label.
Notes
-
Selecting a row or column field also selects all of the items of data in the field.
-
If detail data is displayed for several items so that the field label is displayed more than once, clicking one instance of the field label selects all instances.
-
Formats that you apply affect the data cells of all total fields in the view.
-
To select a single item, click the item label. To add more items to the selection, press and hold the CTRL key when clicking the item labels.
-
To select a range of items, click the label of the first item, press SHIFT, and then click the label of the last item.
Notes
-
Selecting an item selects all of the data for that item.
-
Formats that you apply to one item affect all other items in the field.
Select a subtotal or grand total
-
Click the subtotal or grand total.
Note Selecting a subtotal or grand total also selects all of the data for the subtotal or grand total.
-
Click Properties
on the PivotTable toolbar, and then click the Captions tab. -
In the Select caption list, select the item you want.
Note Formats that you apply to a drop area do not affect other drop areas.
Select an element in PivotChart view
-
Open a datasheet or form in PivotChart view.
- Click once on the item in the chart you want to select. To select an entire group of items, such as an entire data series, click a second time.
Note You can also select items in the Select box on the General tab of the Properties dialog box (click Properties
on the PivotChart toolbar). For example, to select the first value axis on the chart, click Value Axis 1 in the Select box.