Oct 25 2021 07:32 AM
I'm trying to start a new line of text inside a cell in Excel.
I've always done this by simply pressing alt + enter.
But now it's jumping to the cell below (instead of a new line within the cell).
Can anyone please tell me what happened, and how I can fix this?
Oct 25 2021 07:47 AM
You have to stay in the line after the text with the courser flashing, only then press Alt + Enter.
In this way you can create a line wrap several times in the same cell.
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Oct 25 2021 07:52 AM
Oct 25 2021 07:58 AM
To my knowledge there is no such setting. Please check Alt+Enter Stopped Working Correctly (Microsoft Excel) (tips.net) if helps.
Oct 25 2021 08:20 AM
Oct 25 2021 08:32 AM
As far as I could understand the text, it is mostly due to the language selection,
but with my Excel 2016 where I tried it, it works without problems,
just has to be in the cells and it always works.
It's weird, even though I keep changing the language selection.
Will probably be like that when it was tried out by excel specialists ... luckily not with my excel :)).
Oct 25 2021 08:37 AM
Oct 25 2021 08:57 AM
As already described above by Mr. @Sergei Baklan, Alt + Enter Stopped Working Correctly, you can see the link in his post.
That it works for me doesn't mean that it works for someone else too, read the article.
Thank you for your understanding
Oct 25 2021 09:33 AM
Oct 25 2021 09:53 AM
Oct 25 2021 10:15 AM
Oct 25 2021 10:16 AM
Oct 25 2021 10:36 AM
Oct 25 2021 10:49 AM
Strange, it works for me without any problems ... just click behind the existing text,
coursor flashes and Alt + Enter,
new text entered and just enter
and the line break appears with the new text added.
As Mr. Baklan already informed us with his link, there is a temporal bug in this command.
Try manual cell wrapping by clicking on all cells to wrap in advance, or the alternative method Right-click the cell whose text you want to break, then click Format Cells.
On the Alignment tab, select the Word wrap check box and click OK.
Unfortunately, I can't help in any other way at the moment.
Nevertheless, I wish you a lot of fun with Excel.
Oct 25 2021 12:09 PM
Oct 25 2021 12:23 PM
Oct 25 2021 01:11 PM
You are welcome, but that's thanks to Allen Wyatt: "You might also want to try a different keyboard with your system." I guess he covered all possible reasons.