Share via

How to break line inside an Exel cell

prnews 1 Reputation point
2021-07-21T15:29:31.733+00:00

Hi, is it possible to enter a long line of content inside a cell with line breaks?
Not by wrap text, but break lines at the words that you desire.

Thanks.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,746 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,796 Reputation points
    2021-07-21T15:36:21.18+00:00

    It can be done by pressing ALT + Enter key.. Have you tried it? Please correct me if I misunderstood the question

    https://www.ablebits.com/office-addins-blog/2020/03/25/start-new-line-excel-cell-carriage-return/

    2 people found this answer helpful.
  2. Paul 25 Reputation points
    2024-12-29T11:56:45.91+00:00

    Here is another example of forcing text wrapping inside a formula using the char() command. For anyone else trying this formula example it uses iterative formulas i.e. it references itself to keep date initially set the first time a number greater than 0 is added to any of the referenced cells. This can be enabled by clicking file - options - formulas - enable iterative formulas.

    the &CHAR(10)& string will combine existing bits of output data in your formula with the carriage returns where they are needed.

    =IF(MAX(N2:N100)>0,IF(N1="",TEXT(TODAY(),"DDD"&CHAR(10)&"DD MMM"&CHAR(10)&"YYYY"),N1),"")

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.