Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheila in CA
 
Posts: n/a
Default Comments don't stay the size I choose.

I have formatted and saved my comment boxes to fit their content, but they
don't keep that size. I haven't hidden comments--which is the ONLY reason MS
gives for them changing their size. Comments are all different sizes, not
even uniform. What is the real reason for the change?! Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Lunn
 
Posts: n/a
Default Comments don't stay the size I choose.



"Sheila in CA" wrote:

I have formatted and saved my comment boxes to fit their content, but they
don't keep that size. I haven't hidden comments--which is the ONLY reason MS
gives for them changing their size. Comments are all different sizes, not
even uniform. What is the real reason for the change?! Thanks.


Click the comment and you should get a border like this //////. Click the
border again and it then should change to dots. Right click the border and
choose Format Comment. Choose Alignment and tick the Automatic Size box and
click OK.

Should keep it's size this way. HTH
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
Combo Box font size in Charts Shirley Munro Charts and Charting in Excel 0 October 27th 05 12:38 PM
Font size in conditinal formatting GDC Excel Discussion (Misc queries) 0 October 18th 05 06:38 PM
Default font for Comments Debra Dalgleish Excel Worksheet Functions 0 August 25th 05 11:55 PM
In a yes or no situation how do I choose a sample size Stat Challenged Excel Discussion (Misc queries) 3 July 26th 05 07:04 PM
How can I choose A3 paper size for worksheet without connecting A. da_the_van Excel Discussion (Misc queries) 1 November 26th 04 04:01 PM


All times are GMT +1. The time now is 08:15 AM.

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

About Us

"It's about Microsoft Excel"