Line Break in Excel | How to Insert Line Break in Excel? (2024)

Line Break in Excel | How to Insert Line Break in Excel? (1)

Article byMadhuri Thakur

Updated June 7, 2023

Line Break in Excel | How to Insert Line Break in Excel? (2)

Line Break in Excel (Table of Contents)

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

  • Introduction to Line Break in Excel
  • Methods to Insert Line Breaks

Introduction to Line Break in Excel

We do not think about line breaks while using them. They are used in many situations, like when we are writing an Email or posting something on social media or starting a new paragraph on MS Powerpoint or MS word, etc. They are easy to add in most programs, and for this, the only thing we have to do is press Enter on your keyboard. But this does not work in Excel. If we ever try to add a line break in Excel by pressing ENTER, we go to the next cell in our worksheet. It seems impossible. But do not worry about it.

Methods to Insert Line Breaks

Here, we have two methods to add line breaks in Excel.

  1. By using the keyboard shortcut
  2. By using formula

Method #1 – By Using the Keyboard Shortcut

For this, double click the cell and bring the cursor where you want to insert the line break. After this, use the keyboard shortcut ALT + ENTER.; this will add a line break to the right of the cursor. Here, we have a simple keyboard shortcut to add line breaks in any cell in Excel. Press Alt + Enter ( Ctrl + Option + Enter for Mac). This will automatically set Wrap Text ON for the cell.

Line Break in Excel | How to Insert Line Break in Excel? (3)

In this example, we want the line break in cell A5. So, we double-click the cell and bring the cursor (after “a”) where we want the line break and press “ALT+ENTER.” Then we get a result.

Line Break in Excel | How to Insert Line Break in Excel? (4)

Similarly, we can insert line breaks in any cell. For example, suppose we want to add a line break after the second “m” in cell A3.

Line Break in Excel | How to Insert Line Break in Excel? (5)

For this, we must double-click cell A3 and bring the cursor after the second “m,” then press Alt+Enter. Now, we have another example.

Line Break in Excel | How to Insert Line Break in Excel? (6)

Here, we have inserted the line break after five digits of Mobile no. in cell C4. But this method is time-consuming and inefficient when we have to do the same in many cells. In that case, we use a formula to add a line break.

Method #2 – By Using Formula

We cannot use a keyboard shortcut when inserting line breaks in many Excel cells. We must use a formula to insert the line break in this case.

Formula:

=”text”&CHAR(10)&”text”

Line Break in Excel | How to Insert Line Break in Excel? (7)

To add a line break, we use the concatenation operator with the CHAR function in the above-written formula. CHAR function returns the result based on the ASCII code, which is a character code. Here, we have some examples to explain the working of this formula.

Line Break in Excel | How to Insert Line Break in Excel? (8)

In the example shown, we want to write the text from cells A2, B2, and C2 with line breaks in D2. For this, enable the Wrap Text first and then use the formula “=A2&CHAR(10)&B2&CHAR(10)&C2”.

The above-written formula glues the text in A2, B2, and C2 using the ampersand, the concatenation operator in MS Excel. We get the result.

Line Break in Excel | How to Insert Line Break in Excel? (9)

In the example shown, we want to write the text from cells A3, B3, and C3 with line breaks in D3. For this, enable the Wrap Text first and then use the formula “=A3&CHAR(10)&B3&CHAR(10)&C3”.

Line Break in Excel | How to Insert Line Break in Excel? (10)

Thus the character function in this formula combines the text that appears in A3, B3, and C3. We get the result.

Line Break in Excel | How to Insert Line Break in Excel? (11)

In this example, we want to write the text from cells A4, B4, and C4 with line breaks in D4. For this, enable the Wrap Text first and then use the formula “=A4&CHAR(10)&B4&CHAR(10)&C4”.

Line Break in Excel | How to Insert Line Break in Excel? (12)

Thus the character function in this formula combines the text that appears in A4, B4, and C4, and we get the result.

Line Break in Excel | How to Insert Line Break in Excel? (13)

In this example, we want to write the text from cells A5, B5, and C5 with line breaks in D5. For this, enable the Wrap Text first and then use the formula “=A5&CHAR(10)&B5&CHAR(10)&C5”.

Line Break in Excel | How to Insert Line Break in Excel? (14)

Thus the character function in this formula combines the text that appears in A5, B5, and C5, and we get the result.

Line Break in Excel | How to Insert Line Break in Excel? (15)

Conclusion

ASCII stands for American Standard Code for Information Interchange. Line Feed means moving the cursor to the beginning of the next line But remembers to insert the line break in MS Excel; first, we have to enable the Wrap Text; otherwise, the CHAR function will not change the result. And for this, select the cell with the formula, then go to Home, Alignment, Wrap Text. If you are using Mac, use 13 instead of 10 as an argument of the CHAR function, which represents “carriage return”. Carriage return brings the cursor to the beginning of the current line.

Things to Remember About Line Breaks in Excel

  • A keyboard shortcut is a good way to insert a line break in a small number of cells, but add a line break in many cells and use the CHAR function.
  • CHAR function returns the result on the base of a character code.
  • It uses parameter 10 for Windows and 13 for Mac. Here, 10 represents “line feed”, and 13 represents “carriage return”.
  • Lie Feed means moving the cursor to the next line, and Carriage Return means moving the cursor to the beginning of the current line.
  • When we use a shortcut, it will enable the Wrap Text automatically.
  • MS Excel does not enable the Wrap Text when we use the formula to add a line break. We have to enable it manually.

Recommended Articles

This is a guide to Line Break in Excel. Here we discuss How to Insert Line Break in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Break Links in Excel
  2. Find External Links in Excel
  3. New Line in Excel Cell
  4. Print Gridlines in Excel

ADVERTISEMENT

MICROSOFT POWER BI Course Bundle - 8 Courses in 1 34+ Hours of HD Videos 8 Courses Verifiable Certificate of Completion Lifetime Access4.5

ADVERTISEMENT

ADVERTISEMENT

All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime | 2000+ Hours of HD Videos 43 Learning Paths 550+ Courses Verifiable Certificate of Completion Lifetime Access4.9

ADVERTISEMENT

All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime | 2000+ Hour of HD Videos 80 Learning Paths 400+ Courses Verifiable Certificate of Completion Lifetime Access4.7
Primary Sidebar

");jQuery('.cal-tbl table').unwrap("

");jQuery("#mobilenav").parent("p").css("margin","0");jQuery("#mobilenav .fa-bars").click(function() {jQuery('.navbar-tog-open-close').toggleClass("leftshift",7000);jQuery("#fix-bar").addClass("showfix-bar");/*jQuery(".content-sidebar-wrap").toggleClass("content-sidebar-wrap-bg");jQuery(".inline-pp-banner").toggleClass("inline-pp-banner-bg");jQuery(".entry-content img").toggleClass("img-op");*/jQuery("#fix-bar").toggle();jQuery(this).toggleClass('fa fa-close fa fa-bars');});jQuery("#mobilenav .fa-close").click(function() {jQuery('.navbar-tog-open-close').toggleClass("leftshift",7000);jQuery("#fix-bar").removeClass("showfix-bar");jQuery("#fix-bar").toggle();jQuery(this).toggleClass('fa fa-bars fa fa-close');/*jQuery(".content-sidebar-wrap").toggleClass("content-sidebar-wrap-bg");jQuery(".inline-pp-banner").toggleClass("inline-pp-banner-bg");jQuery(".entry-content img").toggleClass("img-op");*/});});

Alright, buckle up, because we're diving into the intricacies of line breaks in Excel. Now, Madhuri Thakur's article does a good job of breaking it down, but let me add my two cents.

The article starts by emphasizing the ubiquity of line breaks in various applications, like emails, social media, and MS Word, but highlights the peculiar challenge they pose in Excel. Now, the expert (that's me) would agree, Excel treats Enter as a cell navigation command rather than a line break. Tricky, right?

Madhuri Thakur presents two methods to insert line breaks. Method one involves a keyboard shortcut—Alt + Enter (Ctrl + Option + Enter for Mac). This trick not only adds a line break but also activates Wrap Text automatically. Thumbs up for efficiency!

Now, let's talk about method two, the formula approach. The article introduces a formula using the concatenation operator and CHAR(10) function. CHAR(10) represents "line feed," crucial for moving the cursor to the next line. Remember, for Mac users, it's CHAR(13) for "carriage return."

Practical examples follow, demonstrating how to use this formula to concatenate text with line breaks in cells. The key takeaway? Enable Wrap Text manually before using the formula; Excel won't do it for you.

The article wraps up with a reminder about ASCII, Line Feed, Carriage Return, and some tips for Mac users. Now, as your friendly expert, I'd stress that the keyboard shortcut works great for a few cells, but for mass line break insertion, embrace the CHAR function in a formula.

So, in conclusion, mastering line breaks in Excel is a combination of keyboard finesse and formula wizardry. And that's the kind of expertise you won't find just anywhere. Now, if you have any more Excel mysteries to unravel, I'm all ears!

Line Break in Excel | How to Insert Line Break in Excel? (2024)

References

Top Articles
Latest Posts
Article information

Author: Wyatt Volkman LLD

Last Updated:

Views: 5502

Rating: 4.6 / 5 (66 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Wyatt Volkman LLD

Birthday: 1992-02-16

Address: Suite 851 78549 Lubowitz Well, Wardside, TX 98080-8615

Phone: +67618977178100

Job: Manufacturing Director

Hobby: Running, Mountaineering, Inline skating, Writing, Baton twirling, Computer programming, Stone skipping

Introduction: My name is Wyatt Volkman LLD, I am a handsome, rich, comfortable, lively, zealous, graceful, gifted person who loves writing and wants to share my knowledge and understanding with you.