Cell properties: Alignment and margins

The Alignment and Margins tab controls horizontal and vertical alignment of values and top, bottom, left, and right margins for the selected cells. Mixed horizontal alignment aligns the content of each cell according to its type. For example, dates are right-aligned and text values are left-aligned.

To change alignment or margins for selected cells in a pivot table:

  1. Activate the table.
  2. Select the cell(s) that you want to modify.
  3. From the Format menu or the pop-up menu choose Cell Properties.
  4. Click the Alignment and Margins tab.