Skip to main content

Specifying a Spacer Row or Column

Specifying a Spacer Row or Column

You can display a spacer row or column rather than the selected item or items. To do so:

  1. Click the Advanced Options button next to the item.

    See Customizing Pivot Table Items.

  2. Click Space.

  3. Click OK.

The following shows an example:

pivot table with empty row

For this pivot table, the Rows definition is as follows:

Rows box with Age group, space, and gender items

FeedbackOpens in a new tab