It is possible to add comments to an Excel pivot table, but they don't work well. See the tips and workaround steps below
After you build a pivot table, you might want to add comments to some cells, to explain the data in those cells. However, although you can add comments to a pivot table, they do not work well, and may cause more problems than they solve.
See how to add a comment to an Excel pivot table, and deal with the problems that can occur.
To insert a comment in a regular worksheet cell, you can right-click the cell, and click Insert Comment
However, that Insert Comment command doesn't appear in the popup menu if you right-click on a pivot table cell.
Instead, you can follow these steps to insert a comment, by using a command on the Ribbon
After you add comments to a pivot table, you might have trouble viewing them.
With the default pivot table settings, contextual tooltips appear when you point to a pivot table cell. Those tooltips will override any comments that are in the cell.
In the screen shot below, you can see a red comment marker, but the comment doesn't display when pointing to the cell -- only the tooltip is visible..
To see the comments, you can either
Although the individual comments will not appear when you point to a pivot table cell, you can show or hide all the comments on the worksheet.
All the comments on the sheet are displayed, including any comments in the pivot table. While the comments are displayed, you can also point to a pivot table cell, and see its tooltip.
NOTE: To hide the comments again, click the Show All Comments command, to turn it off.
If you would like to see individual comments, instead of showing all comments, you can turn off the tooltips feature for the pivot table.
After you turn off this setting, the comment appears when you point to the cell.
When you add a comments a pivot table, the comment is attached to the Excel worksheet cell, rather than to a specific item in the pivot table.
If you change the pivot table layout, the comment will NOT move with the pivot item -- it will remain in the original cell. This could end up confusing people who use the pivot table, instead of helping them.
There is no way to change this behavior, so it's best to avoid comments, if the pivot table layout will change.
For example, in the screen shot below, a the fields have been moved in the pivot table layout. The comment is still in cell D6, but that cell now has data for Arrowroot Bars, instead of Banana Bars.
Instead of inserting comments in the pivot table, you could add a column to the source data, and enter brief comments there.
Anyone who has a question about the data in the pivot table could double-click on the pivot table value cell. Or, right-click the cell, and click Show Details
That will trigger the Show Details feature, to extract the source data for the selected data to a new worksheet, where they can read any notes entered.
Download the sample file with the examples from this tutorial. The file is zipped, and is in xlsx format. The file does not contain macros: Pivot Table Comments sample file
Last updated: December 9, 2016 4:40 PM
Contextures RSS Feed