Format the contents of a PivotTable list to read right to left or left to right

Office PivotTable

Format the contents of a PivotTable list to read right to left or left to right

When you select right-to-left display, the elements of the PivotTable list are displayed as a mirror image of the default left-to-right display: The drop areas are on the upper-right side of the PivotTable list, row fields are in the rightmost columns, and items in column fields are listed from right to left.

  1. Click the title bar of the PivotTable list.
  2. Click Commands and Options on the PivotTable list toolbar, and then click the Behavior tab.
  3. Select or clear the Display right to left check box.