Here's how to format PivotTable headers and grand totals in Excel:

Formatting PivotTable Headers:

1. Click anywhere in the PivotTable: This activates the PivotTable Analyze tab on the ribbon.
2. Navigate to Design tab: Click on the "Design" tab.
3. Format Row/Column Headers: In the "Layout" group, you'll find options for formatting row and column headers:
- Change font style, size, and color: Select the header text and use the standard formatting options on the ribbon (Font group).
- Alignment: Right-click on a header and choose "Cell Alignment" to adjust alignment (left, right, center).
- Wrap Text: Right-click on a header and choose "Wrap Text" to display long headers on multiple lines.
- PivotTable Styles: Pre-designed styles with header formatting are available in the "PivotTable Styles" gallery within the Design tab.

Formatting Grand Totals:

1. Select the Grand Total cell(s): Click on the specific grand total cell(s) you want to format (usually located at the bottom or right side of the table).
2. Use standard formatting options: Similar to headers, you can use the formatting options on the ribbon (Font group) to change font style, size, color, etc.
3. Number formatting: Right-click on the grand total cell and choose "Number Format" to apply specific number formatting (e.g., currency, percentages).
4. Show/Hide Grand Totals: In the "Layout" group of the Design tab, you can choose to show or hide grand totals for rows or columns using the "Grand Totals" dropdown menu.

Additional Tips:

* You can format headers and grand totals independently.
* Conditional formatting can be applied to headers or grand totals to highlight specific values based on certain criteria.
* PivotTable settings allow you to choose how grand totals are calculated (Sum, Average, etc.). This can be accessed through the PivotTable Analyze tab.

By using these formatting options, you can customize the appearance of your PivotTable headers and grand totals for better readability and presentation.