+ Reply to Thread
Results 1 to 3 of 3

Excel changes font size when I change color / bold / etc.

  1. #1
    Forum Contributor
    Join Date
    03-26-2015
    Location
    Cookeville, TN
    MS-Off Ver
    Excel 365
    Posts
    202

    Excel changes font size when I change color / bold / etc.

    I have an annoying problem with Excel 2010. My default font size is 10 points. If I select a PORTION of the text within a cell, and then change the properties of that selected text (change the font color, bold it, italicize it, etc.), Excel also changes that text to 8 point size. I have to then manually set it back to 10 points.

    This only happens when I FIRST change the format of a portion of the text within a particular cell. After that, I can change the format of other portions of the text (within the same cell) and Excel will not alter the font size. I can also edit other cells, then come back and make further edits to the original cell, and again the font size will not be altered.

    If I merely select a cell, and change the color or bolding of the entire cell (i.e. ALL the text in the cell), the font size also remains unchanged. The "automatic" change from 10-point (default) to 8-point ONLY occurs the FIRST time that I edit a PORTION of the text within a particular cell. But this is still very annoying, and I can find no explanation of why this is happening. Is there any way to prevent this?

    Further detail: Cells contain lengthy text entries (in default 10-point black normal text). I am highlighting certain portions of that text by changing them to bold red text (still 10-point). When I make the very first format change within a cell (whether I click the bold icon, or the font color [red] icon), my selected text is also changed to 8-point size.

  2. #2
    Registered User
    Join Date
    08-05-2014
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    1

    Re: Excel changes font size when I change color / bold / etc.

    I have the same problem three years later, running Excel 365.

    It happens for me when sheet zoom level is set to 80. My workaround is to set the zoom level to 100 while making these changes.

    Not a satisfying answer but hope it helps someone!

  3. #3
    Registered User
    Join Date
    01-21-2015
    Location
    Melbourne
    MS-Off Ver
    2010
    Posts
    1

    Re: Excel changes font size when I change color / bold / etc.

    Although this has bugged me for ages, I just discovered this zoom explanation for the odd behaviour today (Oct 2022).

    But it's certainly not new - apparently it's existed since at least 2004 as you can see from this Mr Excel forum post:
    (mrexcel.com) board/threads/cell-font-size-changes-when-bold-added.114543/post-566070

    If the bug has lasted 18 years, I don't expect it's going to be fixed anytime soon.

+ 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. How to change font/color/size of a Combo Box? (Excel for Mac 2011)
    By darnesson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-01-2015, 07:22 AM
  2. Mouse rolls over to cell will change the tab color, font color and tp bold type
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-20-2013, 10:36 AM
  3. [SOLVED] For all cells with font size bigger than 9, make that cell bold and color white
    By jasondu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2012, 02:18 PM
  4. How to change font size & bold
    By EMoe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2008, 12:52 AM
  5. how to change to Bold or color font of statusbar
    By newby in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-26-2007, 11:39 PM
  6. Can you keep a cells BOLD Font, cell color size
    By Trese in forum Excel General
    Replies: 2
    Last Post: 08-23-2005, 11:05 AM

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