ICAEW.com works better with JavaScript enabled.
Exclusive

Excel Tips & Tricks

Excel Tips and Tricks #458 - Revisiting Line breaks in Excel

Author: Bani Lamba

Published: 24 Oct 2022

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.

Hello and welcome back to Excel Tips and Tricks! This week we have a short Basic User-level post in which we are going to quickly summarise how line breaks and multi-line formatting works in Excel.

Wrap text

Normally, Excel cells display text that is longer than the cell by overwriting on any blank cells to the right. This continues for as long as necessary:
457
Of course, the edge of the window can also cut off long text.

If we use the option wrap text from the ‘Home’ menu, then Excel will break the text up into the relevant number of lines to show it all:

457
As noted in the image, the Wrap Text button will automatically expand the row height to show all the text; however subsequent changes to the column width or row height don’t automatically adjust the cell size to display all the text.

Adding line breaks

Ordinarily, line breaks are inserted by Excel according to the cell size. But we can add them manually with a line break, created by pressing Alt and Enter:
457
You can also create a line break in a CONCAT or other text formula using the CHAR function – CHAR(10) is the line break character but may not be sufficient on its own. CHAR(10) moves the cursor down 1 line while CHAR(13) is a carriage return which forces the cursor back to the left of the line. It is best practice to use both CHAR(10) and CHAR(13) in combination. You must ensure you have enabled Wrap Text on the cell where this formula is used to enable the line breaks:
457
We cover CHAR along with CODE, UNICODE and UNICHAR in Tip 213.
Archive and Knowledge Base

This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.

Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250