default format for remarks

H

HJ Liang

Anyone can advise how to set the default format for remarks inserted to cells
in Excel?
Thanks.
 
C

Conan Kelly

HJ Liang,

1. Format your comment the way you would like all future comments to be
formatted.
2. Make sure the comment is showing (right-click cell > Show/Hide comments)
3. Right-click comment > Set AutoShape Defaults

Now all new comments should be formatted the same as this one...hopefully.

HTH,

Conan
 
Top