Selecting Pivot Table Elements

  To select a facts column for formatting, layout or modification, click anywhere on the column of data values. Do not click on the label.

  To select a column of Row Labels or a row of Column Labels for formatting, layout, or analysis, click the dimension handle at the end of the column or row of labels.

By default, pivot handles are transparent. They only appear when you select a label from a top or side. When the pivot handle appears, it is shown in white with a light grey handle (). Once the selection is off, the pivot handle is transparent again

  To select one complete row or column for formatting or analysis, press the modifier key Alt for Windows or Ctrl+Alt for Motif. Then, select the row or column label.

  To select an individual Column Label or Row Label for formatting, select the label itself.