Results 1 to 10 of 10

Thread: Excel comments

  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Cosby, Tennessee, USA
    Posts
    126
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I use Excel 7 in Windows 7 Home Premium. I've upgraded from Vista and can't find where to change the size of the font in the comment box. It evidently was changed from the location in Vista. Thanks!

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You can simply select the text in the comment box and change it's font properties using the usual methods.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Cosby, Tennessee, USA
    Posts
    126
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thanks, I know that. In Vista I was able to change all future Font sizes by going to place in appearances called Tool Tips, but I don't find it in Windows 7. That way I wouldn't have to change the size manually everytime I entered a comment.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts
    As you said, the Excel Comment font is inherited from the systemwide ToolTip Setting. Not sure where you find it in Windows 7, but this setting can also be set through the Control Panel; in XP it's under Display | Appearance | Advanced | click the Item dropdown, select ToolTip, change the font settings there. May be necessary to restart the OS for Excel to hook into the new setting, I'm not sure on that point.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Control Panel - Personalization, click the Window Color option, then click 'Advanced appearance settings'.
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Cosby, Tennessee, USA
    Posts
    126
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thanks, who would have thought that font size would be under color! One more question on entering comments. Is there a keyboard shortcut or do have to always use the mouse?

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts
    Quote Originally Posted by smokyken View Post
    One more question on entering comments. Is there a keyboard shortcut or do have to always use the mouse?
    Shift-F2 will insert a new comment in the active cell, or open an existing comment for edit.
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Cosby, Tennessee, USA
    Posts
    126
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thanks, and while we are on the "comments box", is there any whey to do away with the bold heading that always appears in the box without deleting everytime a new box is opened?

  9. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Not directly, no. I use a macro that inserts comments formatted exactly the way I want. It saves messing with the desktop settings. If you like I can post some sample code?
    Regards,
    Rory

    Microsoft MVP - Excel

  10. #10
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Cosby, Tennessee, USA
    Posts
    126
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Not having dealt with macros, I could try. I'm a self taught old man.

Posting Permissions

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