SOLVED

Modify format of a specific text on a cell box

%3CLINGO-SUB%20id%3D%22lingo-sub-3215434%22%20slang%3D%22en-US%22%3EModify%20format%20of%20a%20specific%20text%20on%20a%20cell%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3215434%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EI%20have%20a%20curious%20case%20on%20%3CSTRONG%3EOffice%20365%20Enterprise%20Online%20Excel.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20try%20to%20modify%20a%20specific%2Ffragment%20of%20the%20text%20in%20a%20cell%20box%2C%20I%20can't%20modify%20the%20format%20of%20the%20selected%20text%2C%20but%20if%20I%20select%20the%20entire%20cell%20box%20I%20can%20modify%20the%20format%20of%20all%20the%20text%20on%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20the%20moment%20when%20I%20select%20the%20fragment%20of%20the%20text%20that%20I%20want%20to%20modify%2C%20the%20Start%20panel%20it's%20disabled.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20adding%20two%20photos%2C%20in%20the%20first%20one%2C%20there%20is%20no%20problem%20modifying%20the%20text%20selecting%20the%20entire%20cell.%3C%2FP%3E%3CP%3EOn%20the%20second%20one%2C%20selecting%20just%20one%20word%20of%20the%20phrase%2C%20can't%20modify%20the%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20with%20this%20issue%3F%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20other%20versions%20of%20Excel%20there%20is%20no%20problem%20with%20that.%20I%20have%20this%20issue%20only%20with%20the%26nbsp%3BOffice%20365%20Enterprise%20Online%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Entire%20cell%20box%20selected%3A%20no%20problem%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351373iC12E4DB6286371E7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ENTIRE%20CELL%20BOX.PNG%22%20alt%3D%22Entire%20cell%20box%20selected%3A%20no%20problem%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EEntire%20cell%20box%20selected%3A%20no%20problem%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Specific%20text%20selected%3A%20Can't%20modify%20the%20text%20format%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351374i0B3267ED9BC759F0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MODIFY%20ESPECIFIC%20TEXT.png%22%20alt%3D%22Specific%20text%20selected%3A%20Can't%20modify%20the%20text%20format%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESpecific%20text%20selected%3A%20Can't%20modify%20the%20text%20format%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3215434%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3215463%22%20slang%3D%22en-US%22%3ERe%3A%20Modify%20format%20of%20a%20specific%20text%20on%20a%20cell%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3215463%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318214%22%20target%3D%22_blank%22%3E%40JELW3%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20you%20have%20found%2C%20this%20feature%20is%20not%20available%20in%20the%20web%2Fonline%20version%20of%20Excel.%20You'll%20have%20to%20open%20the%20workbook%20in%20the%20desktop%20version%20of%20Excel%20for%20Windows%20or%20Mac%20OS%20X.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hi!

I have a curious case on Office 365 Enterprise Online Excel.

 

When I try to modify a specific/fragment of the text in a cell box, I can't modify the format of the selected text, but if I select the entire cell box I can modify the format of all the text on it.

 

At the moment when I select the fragment of the text that I want to modify, the Start panel it's disabled. 

I'm adding two photos, in the first one, there is no problem modifying the text selecting the entire cell.

On the second one, selecting just one word of the phrase, can't modify the format.

 

Anyone with this issue? 

Is there a way to do it?

 

In other versions of Excel there is no problem with that. I have this issue only with the Office 365 Enterprise Online Excel.

 

Thank you!

Entire cell box selected: no problemEntire cell box selected: no problem

 

Specific text selected: Can't modify the text formatSpecific text selected: Can't modify the text format

 

 

 

1 Reply
best response confirmed by JELW3 (Visitor)
Solution

@JELW3 

As you have found, this feature is not available in the web/online version of Excel. You'll have to open the workbook in the desktop version of Excel for Windows or Mac OS X.