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.
You could try to use an Excel formula like these
http//
http//
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?
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://
Are you talking of "tooltips" in "data validation", like
http//
?
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
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