ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to change default font size when inserting comments (https://www.excelbanter.com/excel-discussion-misc-queries/132623-how-change-default-font-size-when-inserting-comments.html)

gary m

how to change default font size when inserting comments
 
When inserting a comment in a cell, I would like the default text font to be
Arial size 10. Currently the default is Tahoma size 8. The only instruction I
can find is to insert the comment, then go back and open the indivdual
comment and select the comment text, then change the text settings in the
toolbar. This is getting to be a pain for 150 comments. It would be much
nicer if the comment opened in the font and size I needed.

D.

how to change default font size when inserting comments
 
Here's one way explained

http://j-walk.com/ss/excel/usertips/tip075.htm


Gord Dibben

how to change default font size when inserting comments
 
Gary

Have a look here at Debra Dalgleish's site.

http://www.contextures.on.ca/xlcomments02.html#Default

And for all the rest about Comments see here at same site

http://www.contextures.on.ca/xlcomments01.html


Gord Dibben MS Excel MVP

On Tue, 27 Feb 2007 17:44:00 -0800, Gary M <Gary
wrote:

When inserting a comment in a cell, I would like the default text font to be
Arial size 10. Currently the default is Tahoma size 8. The only instruction I
can find is to insert the comment, then go back and open the indivdual
comment and select the comment text, then change the text settings in the
toolbar. This is getting to be a pain for 150 comments. It would be much
nicer if the comment opened in the font and size I needed.



gary m

how to change default font size when inserting comments
 
Thanks, Gary M

"D." wrote:

Here's one way explained

http://j-walk.com/ss/excel/usertips/tip075.htm




All times are GMT +1. The time now is 06:29 PM.

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