Now I really understand why people say Excel has many features, but nobody knows about them. I often had to type some text in an Excel cell, and I couldn't type one line on a row (in the same cell) as if I pressed
Enter it would have jumped to the same tab. That was annoying and I thought there aren't really easy solutions to do that. Until I considered pressing combinations of keys and Enter. The result, if you press
Alt+Enter while typing in a cell, you'll automatically start the next line on a new row. What this shortcut actually does is enabling the "Wrap text" feature for that cell. See the images below for more visual details.
this is how the text flows if you're not using the automatically wrap feature
this is how the text flows if you're using the wrap feature (see how each line is on a different row)
How this works, you start typing in a cell, and when you want to go to a new line you press
Alt+Enter.
A bonus tip for Excel: If you are beneath a cell that contains data (even a formula) if you press
Ctrl+D the formula will be copied in the new cell (it's a "duplicate" feature, so instead of using copy paste you just press the combination mentioned above.
9 comments:
Thanks, this is just what I was looking for.
This is the help I have been looking for. Thank you so much. It is indeed a great help for an Excel amature like me.
Thanks It really helped
THANKS, I WAS LOOKING FOR THIS.
This is useful, thanks. However, there's a small error: it doesn't enable the "wrap text" feature (as if you right clicked, selected "format cell," and checked the "wrap text" box). All it does is insert a line break.
this has been of great help. Thanks, M Khumalo, South Africa
Thank you so much :D
this was the best thing exactly what i was looking for thank you excell is pretty cool
It DOES enable the wrap text feature, which really is the most idiotic thing about it. My word fits in the cell fine at edit mode and without text wrap, but wrap text wants to drop the last "a" to the next line. I figured that if I use a manual line break to get following word to 2nd line, it would force the first word to stay at first line, but no. You simply can't enter a "manual" line break without wrap text turning on automatically. This is with both Excel 2003 and 2007.
Post a Comment