alt-enter (cell line breaks) is not working in Excel 365.

%3CLINGO-SUB%20id%3D%22lingo-sub-1727573%22%20slang%3D%22en-US%22%3Ealt-enter%20(cell%20line%20breaks)%20is%20not%20working%20in%20Excel%20365.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1727573%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tried%20Ctrl%2BEnter%2C%20Windows%2BAlt%2BEnter.%20etc.%20but%20unable%20to%20start%20a%20new%20line%20in%20a%20cell%20in%20Excel%20365.%20Please%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1727573%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1727700%22%20slang%3D%22en-US%22%3ERe%3A%20alt-enter%20(cell%20line%20breaks)%20is%20not%20working%20in%20Excel%20365.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1727700%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F814373%22%20target%3D%22_blank%22%3E%40vipinchaudhary%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMake%20sure%20that%20you%20turn%20on%20Wrap%20Text%20in%20the%20Alignment%20group%20of%20the%20Home%20tab%20of%20the%20ribbon%20for%20the%20cells%20in%20which%20you%20want%20line%20breaks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have tried Ctrl+Enter, Windows+Alt+Enter. etc. but unable to start a new line in a cell in Excel 365. Please help.

3 Replies

@vipinchaudhary 

Make sure that you turn on Wrap Text in the Alignment group of the Home tab of the ribbon for the cells in which you want line breaks.

@Hans Vogelaar This still doesn't work. 

@Discoverer 

That's weird.

What happens if you do the following?

  • Enter the formula ="One"&CHAR(10)&"Two" in a cell.
  • Turn on Wrap Text for that cell.
  • If necessary, increase the row height.

Do you see two lines in the cell?