Excel: How to enter Line Break within Cell
Question by HomeMan | Last update on 2022-07-27 | Created on 2015-02-12
Recently, I got a Microsoft Excel document (XLXS format) in which there was a linebreak included in one of the fields. I was very surprised to see that, because normally, the content of Excel cells are only written in one line.
Of course, I have tried to create my own line break within a cell, but whenever pressing the enter key, Excel only jumps to the next cell instead of typing a line jump.
How is it possible to write two lines into one cell of the table? Is there any trick for multiline fields in Excel?
Related Topics
XLS and XLSX: Maximum Number of Columns and Rows
Info | 2 Comments
Rewrite Text Files with a fixed Line Length
Tutorial | 0 Comments
How to Replace multiple Texts at the same Time
Tutorial | 0 Comments
Repair Text Files with mixed Line Breaks
Tutorial | 0 Comments
jQuery: Assign Action to Keyboard Keys (Keyboard Event)
Tip | 0 Comments
Delphi: Multiline Caption for TLabel (at Run Time and Design Time)
Tutorial | 1 Comment
OpenOffice Calc: Line Break within a Cell
Question | 1 Answer
Important Note
Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more.
Participate
Ask your own question or write your own article on askingbox.com. That’s how it’s done.
Just pressing the enter key only makes Excel to jump to the field below.
In order to create a line break within a cell, you have to press ALT + ENTER simultaneously.
However, when using OpenOffice or LibreOffice, you have to use another key combination. Here, you can learn more about that.
Last update on 2022-07-27 | Created on 2015-02-12