Forum Discussion

jwongsf's avatar
jwongsf
Copper Contributor
Jun 20, 2020
Solved

Excel Display being truncated in cell

I am typing in a cell and the text exceeds the width of the cell, normally the text would just overlap into the next cell as long as there is no text in the cell. However, I have check the adjunction...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 21, 2020

    Sorry for the duplication: Detlef_Lewin 's previous post didn't show up until after I posted mine.

     

     

    jwongsf You probably activated "Show Formulas" in the Formulas ribbon. 

    Deactivate it and it will result in this:

jwongsf's avatar
jwongsf
Copper Contributor
Jun 20, 2020

SergeiBaklan 

Hi Sergei

you are getting the same display that I am seeing, in the Past if you exceed the with of the cell it would display the rest of the text into the next cell unless the cell was not blank. But it is not display this currently and I am wonder what option is prevent this from being displayed

Thanks

James

 

jwongsf's avatar
jwongsf
Copper Contributor
Jun 20, 2020

Here is the file that that displays what I am seeing,

Thanks

 

    • jwongsf's avatar
      jwongsf
      Copper Contributor
      Jun 21, 2020

      Detlef_Lewin Sorry this did nothing to the cell>

       

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Jun 21, 2020

        Sorry for the duplication: Detlef_Lewin 's previous post didn't show up until after I posted mine.

         

         

        jwongsf You probably activated "Show Formulas" in the Formulas ribbon. 

        Deactivate it and it will result in this:

Resources