EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Line Break in Excel

Line Break in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated June 7, 2023

Line Break in Excel

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 1-1

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 1-2

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 1-3

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 1-4

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”

Using Formula 1

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.

Using Formula 2

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.

Using Formula 3

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”.

Using Formula 4

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

Using Formula 5

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”.

Using Formula 6

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

Using Formula 7

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”.

Using Formula 8

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

Using Formula 9

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
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
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 Access
4.9
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 Access
4.7
Primary Sidebar
Popular Course in this category
FINANCIAL MODELING & VALUATION Course Bundle - 51 Courses in 1 | 30 Mock Tests | World's #1 Training
 278+ Hours of HD Videos
51 Courses
30 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.6
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more