This is a trivial but irritating problem that I'm sure can be solved,
but I've tried everything I can think of.

The problem is that when I select a cell in Excel 2000 (Windows XP) to
insert a comment, the Comment box is pre-formatted with my name, a
colon and a hard return, and it's also set to bold-face.

So, every time I add a new comment I have to delete all the text and
set it to non-bold, which is somewhat time-consuming (although not as
time-consuming in the aggregate as the amount of time I've spent trying
to find the setting that started all this), and also irritating.

Where can I turn off or reset this default format?

Thanks.

If you want to permantly change the format of comments, go to the
windows control panel, select display, appearance, advanced. Select
tooltips and choose the format that you want.

BUT ........ this will change the format of all tooltips for all your
windows applications.

This will not change existing comments.


--
jujuwillis
------------------------------------------------------------------------
jujuwillis's Profile: http://www.excelforum.com/member.php...fo&userid=2123
View this thread: http://www.excelforum.com/showthread...hreadid=571135

From Excel HELP:

"You can change the name that appears when you insert new comments, but you
can't keep Microsoft Excel from including your user name."

Irritating is putting it mildly!

"HumingBean" wrote:

This is a trivial but irritating problem that I'm sure can be solved,
but I've tried everything I can think of.

The problem is that when I select a cell in Excel 2000 (Windows XP) to
insert a comment, the Comment box is pre-formatted with my name, a
colon and a hard return, and it's also set to bold-face.

So, every time I add a new comment I have to delete all the text and
set it to non-bold, which is somewhat time-consuming (although not as
time-consuming in the aggregate as the amount of time I've spent trying
to find the setting that started all this), and also irritating.

Where can I turn off or reset this default format?

Thanks.

Check out Debra Dalgleish's web site:

http://www.contextures.com/tiptech.html

Scroll down to the C's, and you'll find just about all the answers to your
questions on "Comments", including changing formats, name, and anything
else!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"HumingBean" wrote in message
ups.com...
This is a trivial but irritating problem that I'm sure can be solved,
but I've tried everything I can think of.

The problem is that when I select a cell in Excel 2000 (Windows XP) to
insert a comment, the Comment box is pre-formatted with my name, a
colon and a hard return, and it's also set to bold-face.

So, every time I add a new comment I have to delete all the text and
set it to non-bold, which is somewhat time-consuming (although not as
time-consuming in the aggregate as the amount of time I've spent trying
to find the setting that started all this), and also irritating.

Where can I turn off or reset this default format?

Thanks.