| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comment Notations
Excel 2007
A friend at work wonders if there is a way to print the little red triangle that appears in the upper righthand corner of cells when a comment is attached. We've searched and found how to print comments, but she just wants the "notation" of a comment to print rather than the whole comment. She uses the comments to let herself know when she's completed a task associated with a cell's information - that is why she only needs the notation to print. Thank you for your help! Pippercat |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comment Notations
Personally, I would use another column with an indicator.
But you could add a shape over that comment indicator if you wanted. See Debra Dalgleish's site for more info: http://www.contextures.com/xlcomments03.html#Indicator Pippercat wrote: Excel 2007 A friend at work wonders if there is a way to print the little red triangle that appears in the upper righthand corner of cells when a comment is attached. We've searched and found how to print comments, but she just wants the "notation" of a comment to print rather than the whole comment. She uses the comments to let herself know when she's completed a task associated with a cell's information - that is why she only needs the notation to print. Thank you for your help! Pippercat -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comment Notations
Very easy. Hi-light the cell range and copy as picture, then paste into
Paint or PowerPoint and print from there. -- Gary''s Student - gsnu200820 "Pippercat" wrote: Excel 2007 A friend at work wonders if there is a way to print the little red triangle that appears in the upper righthand corner of cells when a comment is attached. We've searched and found how to print comments, but she just wants the "notation" of a comment to print rather than the whole comment. She uses the comments to let herself know when she's completed a task associated with a cell's information - that is why she only needs the notation to print. Thank you for your help! Pippercat |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comment Notations
You need to use VBA.
See http://www.contextures.com/xlcomments03.html#Indicator for a solution. "Pippercat" wrote: Excel 2007 A friend at work wonders if there is a way to print the little red triangle that appears in the upper righthand corner of cells when a comment is attached. We've searched and found how to print comments, but she just wants the "notation" of a comment to print rather than the whole comment. She uses the comments to let herself know when she's completed a task associated with a cell's information - that is why she only needs the notation to print. Thank you for your help! Pippercat |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comment Notations
You could also Copy As Picture, Paste into another sheet in Excel and print
that best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Gary''s Student" wrote in message ... Very easy. Hi-light the cell range and copy as picture, then paste into Paint or PowerPoint and print from there. -- Gary''s Student - gsnu200820 "Pippercat" wrote: Excel 2007 A friend at work wonders if there is a way to print the little red triangle that appears in the upper righthand corner of cells when a comment is attached. We've searched and found how to print comments, but she just wants the "notation" of a comment to print rather than the whole comment. She uses the comments to let herself know when she's completed a task associated with a cell's information - that is why she only needs the notation to print. Thank you for your help! Pippercat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text converted to scientific notations | Excel Discussion (Misc queries) | |||
| Select Range based on column name and not A1 notations | Excel Discussion (Misc queries) | |||
| Lookup text in 1 column and make notations in another | Excel Worksheet Functions | |||
| How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
| a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions | |||
Linear Mode
