If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I change default font for all new comments in Office 2003?
I just installed Office 2003 and transfered excel files from the older
version. The comments that I had created before I moved to 2003 look fine in the default font (Tahoma); however, when I try to insert a new comment, the same font (same size, same formatting) the text looks virtually unreadable. I changed font in some comments and they look much better, but it is extremely inefficient to try to change font in every new comment I insert, so I thought maybe there is a way to do it on a default basis. Or maybe I somehow could change something to make Tahoma appear readable. Please, assist. |
#2
|
|||
|
|||
We have no control over the default font Excel uses with new comments. I
saw no difference in the way the Tahoma font in comments looked in Excel 2003 versus earlier versions. Pretty weird. You can change comment fonts en masse with a macro though... Sub ChgAllCommentFonts() Dim Cell As Range For Each Cell In Cells.SpecialCells(xlCellTypeComments) With Cell.Comment.Shape.TextFrame.Characters.Font .Name = "Terminal" .Size = 9 End With Next End Sub -- Jim "Elena" wrote in message ... |I just installed Office 2003 and transfered excel files from the older | version. The comments that I had created before I moved to 2003 look fine in | the default font (Tahoma); however, when I try to insert a new comment, the | same font (same size, same formatting) the text looks virtually unreadable. I | changed font in some comments and they look much better, but it is extremely | inefficient to try to change font in every new comment I insert, so I thought | maybe there is a way to do it on a default basis. Or maybe I somehow could | change something to make Tahoma appear readable. Please, assist. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do I change the default font in publisher 2003 | Orion | Publisher | 3 | January 20th, 2005 03:54 AM |
How do I change default font in BODY of an event? | klonos | Calendar | 3 | October 23rd, 2004 08:25 PM |
Changing Default Font settings in Comments | boca | General Discussion | 1 | August 11th, 2004 04:59 PM |
How to change Excel comment default font size? (for Office 2000) | Jason | Setting up and Configuration | 1 | December 24th, 2003 03:35 PM |