In the Captions section, you can edit the names of some columns and rows of the pivot table, as well as specify the text that appears in empty cells or cells with errors.

No formula or function may be used as a caption.

The Captions section contains the following boxes:

•Empty cells: Text to display in empty cells of the pivot table.

•Errors: Text to display in cells that contain errors in calculations.

•Grand total: The name of the row and column with the grand totals.

•Values: This field is not used in the current version of the application.

•Rows: The name of rows in the pivot table with a compact layout.

•Columns: The name of columns in the pivot table with a compact layout.

If there is no value in the field, enter a value manually and press Enter.

If there is a value in the field, delete it manually or by clicking the side_panel_pivot_table_close button. Then enter the desired value and press Enter.

Was this helpful?

Yes