how to change default font size when inserting comments

[Gary M]

When inserting a comment in a cell, I would like the default text font to be
Arial size 10. Currently the default is Tahoma size 8. The only instruction I
can find is to insert the comment, then go back and open the indivdual
comment and select the comment text, then change the text settings in the
toolbar. This is getting to be a pain for 150 comments. It would be much
nicer if the comment opened in the font and size I needed.

 

[D.]

Here's one way explained

http://j-walk.com/ss/excel/usertips/tip075.htm

 

[Gord Dibben]

Gary

Have a look here at Debra Dalgleish's site.

http://www.contextures.on.ca/xlcomments02.html#Default

And for all the rest about Comments see here at same site

http://www.contextures.on.ca/xlcomments01.html


Gord Dibben MS Excel MVP

 

[Gary M]

Thanks, Gary M