| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Comments- just the corner
Is it possible to print a spreadsheet that has comments - and only print the
little triangle in the corner? I want to be able to recognize whether or not a cell has comments attached, but I dont want to print them below, or where they are on the sheet. I also don't want to use cell shading to distinguish them, as im using shading for other purposes. If anyone can help that would be great! Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing Comments- just the corner
Debra Dalgleish shows how to put a shape over that comment indicator and that
will print (well, if you have the shape printed)... http://contextures.com/xlcomments02.html#Colour Derrick wrote: Is it possible to print a spreadsheet that has comments - and only print the little triangle in the corner? I want to be able to recognize whether or not a cell has comments attached, but I dont want to print them below, or where they are on the sheet. I also don't want to use cell shading to distinguish them, as im using shading for other purposes. If anyone can help that would be great! Thanks, -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing Comments- just the corner
thanks, but i'd rather not have code for this sheet.
are there no settings for printing it? Derrick "Dave Peterson" wrote: Debra Dalgleish shows how to put a shape over that comment indicator and that will print (well, if you have the shape printed)... http://contextures.com/xlcomments02.html#Colour Derrick wrote: Is it possible to print a spreadsheet that has comments - and only print the little triangle in the corner? I want to be able to recognize whether or not a cell has comments attached, but I dont want to print them below, or where they are on the sheet. I also don't want to use cell shading to distinguish them, as im using shading for other purposes. If anyone can help that would be great! Thanks, -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing Comments- just the corner
Not that I've seen.
If your range is small enough, you could a print-screen and paste the picture into MSWord (or another application). Derrick wrote: thanks, but i'd rather not have code for this sheet. are there no settings for printing it? Derrick "Dave Peterson" wrote: Debra Dalgleish shows how to put a shape over that comment indicator and that will print (well, if you have the shape printed)... http://contextures.com/xlcomments02.html#Colour Derrick wrote: Is it possible to print a spreadsheet that has comments - and only print the little triangle in the corner? I want to be able to recognize whether or not a cell has comments attached, but I dont want to print them below, or where they are on the sheet. I also don't want to use cell shading to distinguish them, as im using shading for other purposes. If anyone can help that would be great! Thanks, -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing Comments- just the corner
ps. You could insert the shapes manually yourself.
Derrick wrote: thanks, but i'd rather not have code for this sheet. are there no settings for printing it? Derrick "Dave Peterson" wrote: Debra Dalgleish shows how to put a shape over that comment indicator and that will print (well, if you have the shape printed)... http://contextures.com/xlcomments02.html#Colour Derrick wrote: Is it possible to print a spreadsheet that has comments - and only print the little triangle in the corner? I want to be able to recognize whether or not a cell has comments attached, but I dont want to print them below, or where they are on the sheet. I also don't want to use cell shading to distinguish them, as im using shading for other purposes. If anyone can help that would be great! Thanks, -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing Comments- just the corner
Haha. Thanks but no thanks.. I have soo many comments.
Thanks for your help anyways, Derrick "Dave Peterson" wrote: ps. You could insert the shapes manually yourself. Derrick wrote: thanks, but i'd rather not have code for this sheet. are there no settings for printing it? Derrick "Dave Peterson" wrote: Debra Dalgleish shows how to put a shape over that comment indicator and that will print (well, if you have the shape printed)... http://contextures.com/xlcomments02.html#Colour Derrick wrote: Is it possible to print a spreadsheet that has comments - and only print the little triangle in the corner? I want to be able to recognize whether or not a cell has comments attached, but I dont want to print them below, or where they are on the sheet. I also don't want to use cell shading to distinguish them, as im using shading for other purposes. If anyone can help that would be great! Thanks, -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| printing comments. | Excel Discussion (Misc queries) | |||
| Printing comments | Excel Discussion (Misc queries) | |||
| Comments - Printing | Excel Discussion (Misc queries) | |||
| insert 2 colours in a single cell,corner to corner | Excel Worksheet Functions | |||
| Page #s and bottom corner dates have disappeared in printing. | Excel Discussion (Misc queries) | |||
Linear Mode
