Forum Discussion
alt-enter (cell line breaks) is not working in Excel 365.
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!!
Thanks Discoverer : finally worked. Weird though.
- Yay Thanks for trick
what is super weird is that left alt +enter doesnt work but right alt +enter does!!Discoverer
- Thanks for help.. I was struggling too. What I was doing that simply a laptop restart to make the right Alt again. Interestingly when I applied your WA ( using the left Alt ) once then right Alt started working again... this means that code is somehow getting updated in memory after applying the WA. So this is a bug ..not a feature I guess
When you’re in your cell, do a Option + Enter.
Check the keyboard layout and change it to US"
You can find it using Windows+Space
select the US Keyboard. Maybe this will help you to fix the problem.
Many thanks for the hint. Microsoft has weird improvements.
- Thanks a lot!!!!
Thank you very much. Discoverer
F** Man. Finally worked. Thanks!!
- 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're a saviour! Thank you so much for taking the time to update what worked for you!
- not working on my laptop I am using Aaus laptop
