ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   comment indicator changing the color or hiding the indicators (https://www.excelbanter.com/excel-discussion-misc-queries/43685-comment-indicator-changing-color-hiding-indicators.html)

Giovanni

comment indicator changing the color or hiding the indicators
 
How can I change the red triangle to a clear triangle so it will not show up
in the document. I still want the comment to pop up when i click on that
cell. I just do not want the indicator to show.

D Hilberg

You can't do it so easily. There is a workaround:

Tools|Options|View, set Comments to "None".
To read a comment, RIGHT-click on the cell and choose "Edit Comment".
(When done reading comment, click somewhere else, or hit Escape twice.)

The comment will not appear when you pass your cursor over the cell;
you have to know which cell to right-click.

- David

Giovanni wrote:
How can I change the red triangle to a clear triangle so it will not show up
in the document. I still want the comment to pop up when i click on that
cell. I just do not want the indicator to show.



Cutter


One way to do it would be to make a small rectangle from the drawing
toolbar.
Format it with no lines and same fill colour as the cell.
Fit it over the comment indicator and size it so that it's just big
enough to hide it.

Once you've done the first one you can copy it into the other cells
containing comments.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=401578



All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com