Forum Discussion
alt-enter (cell line breaks) is not working in Excel 365.
I have tried Ctrl+Enter, Windows+Alt+Enter. etc. but unable to start a new line in a cell in Excel 365. Please help.
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!!
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
I have been struggling with this almost everyday for the last year and not found an answer. Thank you so much for ending the hard return chaos in my work life!
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.
LaRai655 thanks a lot it wasnt working for me also,
but how to reuse it without pressing windows key as it used to be previously
- 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 😞
