new line in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2464744%22%20slang%3D%22en-US%22%3Enew%20line%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2464744%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20lost%20the%20ability%20to%20create%20a%20new%20cell%20in%20excel%20using%20alt%20return%26nbsp%3B%3C%2FP%3E%3CP%3Ealso%20tried%20cntrl%20return%20and%20alt%20control%20return%20but%20nothing%20works...%20please%20help%20before%20I%20throw%20this%20laptop%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2464744%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2464764%22%20slang%3D%22en-US%22%3ERe%3A%20new%20line%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2464764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1082866%22%20target%3D%22_blank%22%3E%40Debs-at-work%3C%2FA%3E%26nbsp%3BAlt-Enter%20produces%20a%20line%20feed%20when%20entered%20inside%20a%20cell.%20In%20order%20to%20see%20the%20sentence%20break%20into%20separate%20lines%20you%20need%20to%20set%20the%20cell%20to%20wrap%20text.%20In%20the%20picture%20below%2C%20both%20cells%20contain%20the%20exact%20same%20text.%20One%20with%20wrap%20text%20OFF%20and%20the%20other%20with%20wrap%20text%20ON%20(top%20right%20hand%20corner).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-06-19%20at%2005.52.47.png%22%20style%3D%22width%3A%20423px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F290069i8136B4430CE1B010%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-06-19%20at%2005.52.47.png%22%20alt%3D%22Picture%20taken%20on%20a%20Mac.%20Similar%20for%20PC!%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EPicture%20taken%20on%20a%20Mac.%20Similar%20for%20PC!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I've lost the ability to create anew line cell in excel using alt return 

also tried cntrl return and alt control return but nothing works... please help before I throw this laptop !

1 Reply

@Debs-at-work Alt-Enter produces a line feed when entered inside a cell. In order to see the sentence break into separate lines you need to set the cell to wrap text. In the picture below, both cells contain the exact same text. One with wrap text OFF and the other with wrap text ON (top right hand corner).

 

Picture taken on a Mac. Similar for PC!Picture taken on a Mac. Similar for PC!