Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 16th 05, 01:44 PM
ArtieF
 
Posts: n/a
Default Change default font and size in Comments box in Excel.

How do I change the default font and font size in the Comments box in Excel?
It's bothersome to change the default font everytime I use a new Comments
box. Thanks for your assistance.

  #2   Report Post  
Old September 17th 05, 11:35 AM
Gary''s Student
 
Posts: n/a
Default

As a start, look at:

http://www.exceltip.com/st/Changing_...ormat/187.html
--
Gary''s Student


"ArtieF" wrote:

How do I change the default font and font size in the Comments box in Excel?
It's bothersome to change the default font everytime I use a new Comments
box. Thanks for your assistance.

  #3   Report Post  
Old September 19th 05, 04:37 PM
Loris
 
Posts: n/a
Default

I've tried changing the Comment format in Excel and find that I can change
the font size abd attributes such as bold but not the font itself. My system
defaults to Tahoma and doesn't change regardless of what I specify in the
Appearance Tab of the Display Properties dialog box. The tooltips change
font but not the comments. That may be hard coded in Excel. Anyone else
find this to be true or am I missing something?

"Gary''s Student" wrote:

As a start, look at:

http://www.exceltip.com/st/Changing_...ormat/187.html
--
Gary''s Student


"ArtieF" wrote:

How do I change the default font and font size in the Comments box in Excel?
It's bothersome to change the default font everytime I use a new Comments
box. Thanks for your assistance.

  #4   Report Post  
Old September 19th 05, 05:27 PM
David McRitchie
 
Posts: n/a
Default

That is correct, you can change the font after creation but you cannot
change the default fault from Tahoma.
http://www.mvps.org/dmcritchie/excel/ccomment.htm#font
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Loris" wrote in message ...
I've tried changing the Comment format in Excel and find that I can change
the font size abd attributes such as bold but not the font itself. My system
defaults to Tahoma and doesn't change regardless of what I specify in the
Appearance Tab of the Display Properties dialog box. The tooltips change
font but not the comments. That may be hard coded in Excel. Anyone else
find this to be true or am I missing something?

"Gary''s Student" wrote:

As a start, look at:

http://www.exceltip.com/st/Changing_...ormat/187.html
--
Gary''s Student


"ArtieF" wrote:

How do I change the default font and font size in the Comments box in Excel?
It's bothersome to change the default font everytime I use a new Comments
box. Thanks for your assistance.





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
How do I change the Font Default for Comment in Excel 2000? Karla Excel Discussion (Misc queries) 3 September 20th 05 11:20 PM
Default font for Comments Debra Dalgleish Excel Worksheet Functions 0 August 25th 05 11:55 PM
How do I change default font for all new comments in Office 2003? Elena Excel Discussion (Misc queries) 1 April 1st 05 09:30 PM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM
how do i set default font / text size in comments? philk Setting up and Configuration of Excel 1 November 28th 04 03:20 PM


All times are GMT +1. The time now is 07:12 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017