Procedures - Formatting Custom Reports in Excel

You can modify the layout of custom reports in Excel.

In an Excel PivotTable report, you find formatting and layout options in the following locations:

• PivotTable Options dialog box
• Field Settings dialog box
• Design tab
• Options tab
• Shortcut menu when you right-click a report row or column

The Options tab and Design tab are visible after you click any cell in the PivotTable report layout area. You also see a PivotTable Tools label above the tabs when they display. If your mouse pointer is in a cell outside the PivotTable area, these tabs do not display.