Forum Discussion

Maciej Fox's avatar
Maciej Fox
Copper Contributor
Oct 08, 2017
Solved

Problems with formating text within a cell.

04.10.2017, 22:09 Uhr |  33 |  1   Hello. Since recently I have an annoying problem with Excel. I have a desktop computer, using Windows 10 Home Edition 64 bit with Excel 2016: Since a couple...
excel
formating
text
unwanted
Tom Oliver's avatar
Tom Oliver
Copper Contributor
Oct 13, 2017

Yeah, it's sometimes intermittant? I notice it sometimes doesn't trigger if I have other excel documents open.

I recorded a quick video of it happening in a new, clean VM (win 10 16257 & office 1708)

 

https://webmshare.com/play/3yY6q

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 13, 2017

Hi Tom,

 

It looks like that bug

===

Fixes or workarounds for recent issues in Excel for Windows - Excel

Font formatting is lost when using rich text in Excel 2016 [WORKAROUND]

Last updated: October 11, 2017

ISSUE

When opening a file in Excel 2016 that contains multiple types of text formatting within the same cell, the formatting may be lost. Examples include having some rich text bolded and others in the same cell not bolded, or having different font colors for different characters within the same cell, such as the example below.

===

https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093?ui=en-US&rs=en-US&ad=US

  • Eva Vogel's avatar
    Eva Vogel
    Iron Contributor
    Oct 18, 2020
    Hi Vecrumba, you can always say your complaints on Microsoft’s „UserVoice“. And you can find it in your home tab in excel when clicking on the smiley Icon on the upper right of your desktop app. And you can always define your own individual styles on formatting each cell if you want. You only have to save it within a „Office Design“. We all have to learn the new routines and I decided to adjust, not to block myself. Feeling enerved or even disgruntled makes no sense at all, I think and you deserve better, on your behalf. So I hope you will have a nice sunday. Greets, Eva
  • Vecrumba's avatar
    Vecrumba
    Copper Contributor
    Oct 17, 2020

    Eva Vogel  I recently migrated to Office 365 after decades of "locally installed." I have mixed font styles (bold, underscore, italic, normal, colors) within spreadsheet cells for years. This sort of flexibility is essential when presenting complex information to senior and/or sophisticated clients. <-For example, pretend this is a spreadsheet legend. Providing styles which apply to entire sheets is fine, but that feature "exchange" eliminating flexibility within cells is choosing style over substance. I am sorely disappointed in the change and your MS response. I find it difficult to believe that this sort of change was socialized with the "power use" community. I certainly would have raised a red flag.

  • Eva Vogel's avatar
    Eva Vogel
    Iron Contributor
    Jan 11, 2019
    Hello Tom! Since Office 2007 we have the Office-wide Designs(thmx-files) to unify your Text formatting, your color palette and your effects on Shapes. You can define a design for all files to fit in a corporate design. Different formattings on characters, words, sentences are a „quick and dirty way“, that works with most people, I know. Nevertheless it’s a good thing to deal with texts in word. And it’s another thing to calculate with excel. You did text formatting with excel, which never was meant to be, in my opinion. It’s not a bug, it’s a long time Intention, I’m sorry...🤭

Resources