comment defaults

yogi · Jul 25, 2008

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 · Jul 26, 2008

Hi Yogi

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

Gord Dibben · Jul 26, 2008

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

comment defaults

yogi

Wigi

Gord Dibben