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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top