comment defaults

[yogi]

how do i set a default for excel cell comments?
i want the font to be standard. i have to edit the comment format for every
comment...there has to be a way to do this!!

 

[Wigi]

Hi Yogi

See here with Debra: http://www.contextures.com/xlcomments03.html#Format

 

[Gord Dibben]

What is your definition of "standard".

Default Font type for Comments is Tahoma and cannot be changed without code.

You can re-size the font.

See Debra Dalgleish's site for tips.

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


Gord Dibben MS Excel MVP