Show All

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

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

1. Open a datasheet or form in PivotTable view.
2. On the PivotTable toolbar, click Properties , and then click the Behavior tab.
3. Select or clear the Display right to left check box.

Note  If the form or datasheet is set for right-to-left display, the PivotTable view will automatically be set for right-to-left display.