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.

12 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?

@vipinchaudhary I encounter the same problem, and I still can't solve it.

@nocturnal_c 

Did you set Wrap text for the cell(s) ?

Finally have the solution - use the alt key to the left of the space bar (and not the one on the right) while simultaneously pressing  the Enter key. This creates another line within the cell. Not sure when did Microsoft make this change!!

@Discoverer  This left Alt worked for me too! Had been struggling through this one since long

Cheers

You're a saviour! Thank you so much for taking the time to update what worked for you!
I have this too but only when using Excel in a Sharepoint spreadsheet. Alt+Return/Enter works in spreadsheets when outside Sharepoint. I'm using Office for Mac 365.
Thank you for the answer, since a year I was struggling to find an answer for Alt -enter in excel sheet. At last, I found it. However, it is a little wired from Microsoft that it works only with the left alt key and not the right side ALt key of space bar. Microsoft to see and sort it out Some times it's frustrating. Thanks @Discoverer

This did not work for me.  (Windows 10 VDI using Excel 2008 13127.21064)  I have to use ALT + Windows + Enter ON THE LEFT to make this work.

You mean left Alt + Enter does not create a new line? I have been using excel 365, so chances are it is different for excel 2008. In any case I do not understand the logic for Microsoft deactivating one of the alt keys for this options. Now one has to use both the hands for the functionality