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.
35 Replies
- On my iPad it is Alt/Option+Enter; perhaps that will work on the Windows version also.
vipinchaudhary
Hi, There are two ALT keys on laptop keyboard. One of them should work. The other one is "alt gr". This is in my HP laptop. Not sure if it is same for yours. But just try.thank you, it worked
vipinchaudharyInterestingly, I have used the left ALT + ENTER for many years and now my 365 is making me use the right ALT. Not sure what makes the keyboard decide which one to use (im on my laptop keyboard) but I remember having the opposite issue when using an external keyboard for my docked laptop at work. Hope they get this under the settings so the user can decide for themselves which one to use as opposed to guessing each time they use office.
Thanks... I was searching for a solution but for me left Alt + Enter Worked....
new line formula(Alt+Enter) is working
vipinchaudhary Like you, the Alt+Enter isn’t working in Excel 365 any longer. So I looked in the Help/Support and here’s the solution, you’ll need to use the onscreen keyboard for this to work (I’m using an iPad). I’ve added the screenshot as it didn’t have a link.
- 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.
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
vipinchaudhary I encounter the same problem, and I still can't solve it.
Did you set Wrap text for the cell(s) ?
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.
HansVogelaar This still doesn't work.
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?
