Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why does Excel seem to ignore formatting that I apply to only part of a cell (e.g. bold or italics on one word of a cell)?

April 26, 2017bold CELL Excel italics word

0

Posted

Why does Excel seem to ignore formatting that I apply to only part of a cell (e.g. bold or italics on one word of a cell)?

1 Answer

0

Posted

This is due to a limitation of the Toolkit’s AutoColor feature. AutoColor does not currently preserve all character properties within a cell (e.g. when only portion of the text in a cell is made bold). For efficiency, only font color, superscripts and subscripts are preserved at the character level within a cell. You can turn off the AutoColor feature by selecting the Tools | Deactivate AutoColor menu option.