Notifications
Clear all

Excel "cell" tooltips  

  RSS
Rampage
(@rampage)
Active Member

Hello )
I'm dealing with a bunch of excel (2003) .xls old files in which authors used to punch in lots of tooltip notes on cells.

obviously opening the files in the native application you can see them but reporting for them is kind of an issue as they are fairly MANY ).

i tried using other tools like OLE deconstructor and examining the files with an hex editors, i can spot them in the hex files but getting them associated to the cell they belong to is not that immediate to explain to a non technical.

so i was wondering if anyone of you were aware of any tool that would help me in the "presentation process" of such information.

Quote
Posted : 23/06/2013 7:01 pm
jaclaz
(@jaclaz)
Community Legend

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

ReplyQuote
Posted : 23/06/2013 7:45 pm
BitHead
(@bithead)
Community Legend

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.

ReplyQuote
Posted : 23/06/2013 7:45 pm
jaclaz
(@jaclaz)
Community Legend

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

ReplyQuote
Posted : 23/06/2013 8:08 pm
Rampage
(@rampage)
Active Member

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.

ReplyQuote
Posted : 23/06/2013 8:18 pm
jaclaz
(@jaclaz)
Community Legend

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

ReplyQuote
Posted : 23/06/2013 8:29 pm
BitHead
(@bithead)
Community Legend

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.

ReplyQuote
Posted : 24/06/2013 3:11 am
harryparsonage
(@harryparsonage)
Active Member

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

ReplyQuote
Posted : 24/06/2013 4:20 am
Share: