Excel "cell" tooltips

You could try to use an Excel formula like these
http//chandoo.org/wp/2009/09/03/get-cell-comments/
http//www.extendoffice.com/documents/excel/765-excel-convert-comments-to-cells.html

If you "fill" another workbook sheet with the "custom" formula, it will be "populated" with the comments of the "original" sheet.

jaclaz

If you create a PivotTable and output the results you could see the values associated with each tooltip. For example if you have a spreadsheet that shows sales and the tooltips are used to select the item, store, price, and discount your PivotTable could show the items, the sales of the item per store, the price the items was sold for, and any discounts that applied to that item.

Is that what you want to generate?

HERE is more on PivotTables.

If you create a PivotTable and output the results you could see the values associated with each tooltip.
…. tooltips are used to select the item, store, price, and discount ….

Which "tooltip"?
Maybe there is a misunderstanding. ?
I thought OP was talking of "cell comments" or "cell notes".
Like
https://xlsxwriter.readthedocs.org/en/latest/_images/comments1.png

Are you talking of "tooltips" in "data validation", like
http//www.brighthub.com/office/home/articles/4906.aspx#imgn_1
?

jaclaz

If you create a PivotTable and output the results you could see the values associated with each tooltip.
…. tooltips are used to select the item, store, price, and discount ….

Which "tooltip"?
Maybe there is a misunderstanding. ?
I thought OP was talking of "cell comments" or "cell notes".
Like
https://xlsxwriter.readthedocs.org/en/latest/_images/comments1.png

Are you talking of "tooltips" in "data validation", like
http//www.brighthub.com/office/home/articles/4906.aspx#imgn_1
?

jaclaz

exactly this one.. yet i managed to do it the dirty way like
"show all comments" from the review tab.

exactly this one.. yet i managed to do it the dirty way like
"show all comments" from the review tab.

Good, then the suggested VBA formulas will do nicely.

jaclaz

Which "tooltip"?
Maybe there is a misunderstanding. ?
I thought OP was talking of "cell comments" or "cell notes"

jaclaz

I was thinking of interactive tooltips where values are returned/validated or where formula help is generated, not comments.

Is printing Comments not one of the print options? In the current version of Excel you can chose to print the comments at the end of the sheet. Check the Help file.

H