Is it possible to change the default font in Excel comments?

GZul · Dec 5, 2005

Can the default font be changed so that when you insert a comment - you start
with that font and size - instead of having to change it repeatedly?

Gord Dibben · Dec 6, 2005

GZul

Not possible to change the default font type without using VBA

See here at Debra Dalgleish's site for programming Comments.

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

You can change the font size.

See also at Debra's site

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

Gord Dibben Excel MVP