Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: change default comment format

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The font that defaults for cell comments is set way too small to read. I wind up changing it everytime. How can I change the default??

  2. #2
    New Member
    Join Date
    May 2002
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Start, Settings, Control Panel
    Double Click Display
    Appearance
    From the Item drop down menu select Tool Tip
    Change the font there

    Quite the rig a mo rll huh

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you for the responce, however I am pretty sure your idea is not my answer. The font that I am having trouble with is not my normal screen display. It is only the default font in the Excel cell comment box. (ie the insert comment function). In fact there is also a defaulted comment that is there initially. It is my computer's name followed by a colon. Of course in tiny little letters that cannot be read. Sorry, this is hard to explain clearly. It seems however that buried somewhere in Excels configuration is the default format for cell comments. I have already verified that the format does not match that of the cell. I have Excel installed on other computers that do not have this same defaulted comment format. Where O Where does it come from?

  4. #4
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dear Mapakunk. I owe a thousand apologies. I have verified that your advice was in fact correct. The tooltip font indeed follows through to the Excel comment font. Your are clearly a wise advisor. Thankyou.
    trout31

  5. #5
    New Member
    Join Date
    Aug 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    mapakunk,

    I also had been looking for this solution and am thrilled to have stumbled onto your posting. The only problem I still have is that the font does not transfer to excel. The size, color, and italics transfers but the actual font remains Tahoma. The font does change for the other window tool tips. Any ideas how I can change the font default for comments? Also it would be nice if I could set the default for auto-size as well.

    Thanks,
    Notewurthy

  6. #6
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you may also want to refer to the following thread where a similar issue was discussed

    http://www.mrexcel.com/board/viewtop...orum=2&start=0

    Regards!

    Yogi

  7. #7
    New Member
    Join Date
    Aug 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Yogi,

    I had already been to that thread but my goal is a little different. I want to change the default font so that all future comment boxes start with the new font.

    Regards,

    Notewurthy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •