Most text editors moves to the next line when you press ENTER. What you have done is essentially entered a line break.
However, things work a bit differently in Microsoft Excel. Instead of entering a line break, Microsoft Excel jumps to the next cell when you press ENTER.
The solution is: Use ALT-ENTER if you want to achieve a line break in a Excel cell.
– You are adding a new line to the text in a cell when you press ALT-ENTER.
– You are jumping from one cell to the cell in the next row when you press ENTER
ah!!!! thank you!!! i’ve always wondered how to do that…i thought excel can’t do that except for using wordwrap…..will try it out….
Judith Serrano-Reyes says
How can i put a center vertical line in 2 cells?