Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default default format for remarks

Anyone can advise how to set the default format for remarks inserted to cells
in Excel?
Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 419
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default Date Format LyndsyJo Excel Discussion (Misc queries) 0 August 30th 07 11:30 PM
Default number format ML Excel Discussion (Misc queries) 1 March 28th 07 04:23 AM
How do i format a default comment Trainman Excel Worksheet Functions 1 February 28th 07 03:57 PM
Default Date Format Loris Excel Discussion (Misc queries) 2 October 10th 06 02:39 AM
Protected worksheet with unprotected cells i.c.w. remarks FrankOtter68 Excel Worksheet Functions 1 April 17th 06 04:21 AM


All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"