If you pivot a grid, it removes all grid customizations except conditional formatting.
The page builder who designs a page determines whether you can pivot the grid.
To pivot a grid:
- In a worksheet toolbar, click
The Pivot data panel displays.
- Drag dimensions to the Context selector, Column or Row sections, and drop the dimension when a horizontal line displays at the required position.
If the Column or Row section contains multiple dimensions, they are nested on the worksheet. Dimensions at the top of a section occupy the outermost position on a grid, and those at the bottom of a section occupy the innermost position on a grid.
- Optionally, swap two dimensions. Drag one dimension over the top of another and drop it when the outline of the dimension changes color.
- To reset your pivot settings to the default for the page, click the Reset pivot button at the bottom of the Pivot data panel.
To close the Pivot data panel, click, or in the top-right of the panel.
Your pivot configuration is remembered by your browser, until you reset the pivot, or your page builder modifies the underlying view. To preserve your pivot, you can select Save personal copy from thePage options toolbar menu of the page, and then apply a pivot to your personal copy in design mode.