+ Reply to Thread
Results 1 to 3 of 3

font size of comment

  1. #1
    Registered User
    Join Date
    01-19-2011
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    76

    font size of comment

    Hi all,
    I want to make font size of comment become biger but apply for all excel file 2016.
    can you help to teach me. Thanks in advance.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: font size of comment

    Hi thaimic,

    I find you can change the font and size of comments and also save this as a Default Shape.

    http://www.howtoexcelatexcel.com/exc...s-comment-box/
    https://support.office.com/en-us/art...6-f1d68e6edda1

    It looks like this feature to Excel may have happened in 2013 Excel and your 2007 may be too old to have this feature.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: font size of comment

    Hey thaimic,

    In the latest version of Excel 365 comments are changing. See the newest explanation of where comments are going at:
    https://efficiency365.com/2019/01/20...ents-in-excel/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Refer .font.name, .font.size, line.dashstyle to a cell instead of hard coding.
    By avarshav in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2016, 11:50 AM
  2. [SOLVED] Setting a comment box default size and font
    By Sam2149 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2014, 08:25 AM
  3. Autosize a Dynamic Comment with Carriage Returns chr(10) with different Font Size.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-06-2011, 07:41 AM
  4. Default Font size in comment boxes ?
    By conks in forum Excel General
    Replies: 2
    Last Post: 08-27-2008, 08:29 AM
  5. [SOLVED] Need feature to change font size default in COMMENT boxes.
    By GED01 in forum Excel General
    Replies: 1
    Last Post: 04-03-2006, 09:25 AM
  6. [SOLVED] How do I change default font size for comment boxes in Excel?
    By Vormov in forum Excel General
    Replies: 1
    Last Post: 10-28-2005, 05:05 PM
  7. [SOLVED] Default cell comment fill color and font size
    By Shadowman13 in forum Excel General
    Replies: 2
    Last Post: 09-28-2005, 04:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1