Cell Text expanding and not expanding

%3CLINGO-SUB%20id%3D%22lingo-sub-1477242%22%20slang%3D%22en-US%22%3ECell%20Text%20expanding%20and%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1477242%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20spreadsheet%2C%20I%20have%20one%20cell%20that%20displays%20text%20exactly%20as%20typed.%26nbsp%3B%20On%20the%20next%20row%2C%20I%20type%20the%20same%20text%20in%20a%20cell%20and%20when%20I%20enter%2C%20it%20expands.%26nbsp%3B%20I%20did%20nothing%20to%20cause%20this%20and%20I%20can't%20find%20any%20differences%20in%20formatting%20for%20either%20cell.%26nbsp%3B%20I%20prefer%20text%20exactly%20as%20typed%20but%20am%20mainly%20looking%20for%20consistency.%26nbsp%3B%20Can%20anyone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1477242%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1478414%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Text%20expanding%20and%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478414%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704825%22%20target%3D%22_blank%22%3E%40tgivens%3C%2FA%3E%26nbsp%3BWhat%20do%20you%20mean%20by%20%22it%20expands%22%3F%20Can%20you%20upload%20a%20screenshot%2C%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1480976%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Text%20expanding%20and%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480976%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20One%20line%20stays%20exactly%20as%20you%20type%20it.%26nbsp%3B%20On%20the%20next%20line%2C%20once%20you%20hit%20enter%2C%20the%20text%20spreads%20out%20to%20the%20right%2C%20out%20of%20the%20bound%20of%20the%20cell%20if%20there's%20enough%20text.%26nbsp%3B%20The%20sentence%20%22expands%22%20beyond%20what%20was%20originally%20typed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481071%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Text%20expanding%20and%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481071%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704825%22%20target%3D%22_blank%22%3E%40tgivens%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELike%20one%20of%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20619px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200051iBC56BCD368F341EE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eor%20something%20different%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481105%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Text%20expanding%20and%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481105%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BNo%2C%20it's%20different.%26nbsp%3B%20I%20have%20attempted%20to%20attach%20a%20file%20which%20shows%20a%20sheet%20illustrating%20the%20problem.%26nbsp%3B%20The%20first%20line%20is%20exactly%20how%20I%20saw%20it%20when%20I%20typed%20it.%26nbsp%3B%20The%20second%20and%20third%20lines%20show%20how%20the%20line%20%22expanded%22.%26nbsp%3B%20And%20I%20can't%20find%20any%20difference%20in%20the%20formatting%20of%20the%203%20lines%2C%20yet%20lines%202%2B3%20added%20space%20between%20letters.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481194%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Text%20expanding%20and%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481194%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704825%22%20target%3D%22_blank%22%3E%40tgivens%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%20different%20fonts%20applied%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20171px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200077i7DAFB03BAF6CBB81%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EDid%20you%20try%20Format%20painter%20first%20cell%20on%20other%20ones%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481275%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Text%20expanding%20and%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481275%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704825%22%20target%3D%22_blank%22%3E%40tgivens%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20see%20extra%20spaces.%20Like%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bsuggested%20it's%20a%20different%20font.%20In%20this%20case%20a%20monospaced%20font%20(each%20character%20has%20the%20same%20width).%3C%2FP%3E%3CP%3EIf%20you%20get%20the%20length%20of%20each%20cell%20it%20should%20be%20same.%3C%2FP%3E%3CP%3E%3DLEN(A1)%3C%2FP%3E%3CP%3E%3DLEN(A2)%3C%2FP%3E%3CP%3E%3DLEN(A3)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20didn't%20you%20upload%20the%20xlsx-file%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481303%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Text%20expanding%20and%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481303%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20Sergei!%26nbsp%3B%20I%20tried%20format%20painter%20and%20was%20able%20to%20make%20all%20of%20the%20cells%20do%20the%20way%20I%20wanted.%26nbsp%3B%20I%20still%20wish%20I%20knew%20why%20it%20had%20changed.%26nbsp%3B%20I%20never%20wanted%20the%20%22expanded%22%20version%20and%20I%20wouldn't%20know%20how%20to%20change%20it%20if%20that%20first%20line%20hadn't%20changed%20to%20%22what%20you%20see%20is%20what%20you%20get%22%20format.%26nbsp%3B%20Anyway%2C%20thank%20you%20again%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481336%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Text%20expanding%20and%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481336%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3BActually%2C%20I%20uploaded%20that%20file%20because%20I%20don't%20know%20how%20to%20do%20a%20screenshot%20and%20I%20needed%20to%20show%20an%20example%20of%20the%20problem.%26nbsp%3B%20Everything%20I%20saw%20in%20the%20spreadsheet%20was%20saying%20each%20line%20had%20the%20same%20font%20but%20it%20seems%20that%20it%20was%20spreading%20the%20letters%20on%20the%202nd%20and%203rd%20line%20after%20I%20hit%20enter.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

In my spreadsheet, I have one cell that displays text exactly as typed.  On the next row, I type the same text in a cell and when I enter, it expands.  I did nothing to cause this and I can't find any differences in formatting for either cell.  I prefer text exactly as typed but am mainly looking for consistency.  Can anyone help?

8 Replies

@tgivens What do you mean by "it expands"? Can you upload a screenshot, please?

@Riny_van_Eekelen  One line stays exactly as you type it.  On the next line, once you hit enter, the text spreads out to the right, out of the bound of the cell if there's enough text.  The sentence "expands" beyond what was originally typed.

@tgivens 

Like one of

image.png

or something different?

@Sergei Baklan No, it's different.  I have attempted to attach a file which shows a sheet illustrating the problem.  The first line is exactly how I saw it when I typed it.  The second and third lines show how the line "expanded".  And I can't find any difference in the formatting of the 3 lines, yet lines 2+3 added space between letters.

@tgivens 

That could be different fonts applied

image.png

Did you try Format painter first cell on other ones?

@tgivens 

I don't see extra spaces. Like @Sergei Baklan suggested it's a different font. In this case a monospaced font (each character has the same width).

If you get the length of each cell it should be same.

=LEN(A1)

=LEN(A2)

=LEN(A3)

 

Why didn't you upload the xlsx-file?

 

 

@Sergei Baklan Thank you Sergei!  I tried format painter and was able to make all of the cells do the way I wanted.  I still wish I knew why it had changed.  I never wanted the "expanded" version and I wouldn't know how to change it if that first line hadn't changed to "what you see is what you get" format.  Anyway, thank you again for your help.

@Detlef Lewin Actually, I uploaded that file because I don't know how to do a screenshot and I needed to show an example of the problem.  Everything I saw in the spreadsheet was saying each line had the same font but it seems that it was spreading the letters on the 2nd and 3rd line after I hit enter.