ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   default format for remarks (https://www.excelbanter.com/excel-worksheet-functions/174903-default-format-remarks.html)

HJ Liang

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

Conan Kelly

default format for remarks
 
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





"HJ Liang" <HJ wrote in message
...
Anyone can advise how to set the default format for remarks inserted to
cells
in Excel?
Thanks.





All times are GMT +1. The time now is 03:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com