Author:Released Date: 

How to start a new line within a cell

How to start a new line within a cell

Introduction

Excel is a spreadsheet software, but you often enter text. Long text should be inserted line breaks, but just pressing enter key make complete entry and move to down.

When we make a line break inside a cell, what should we do? We are introducing how to do it.

Try pressing Enter key

Let’s review what happen when you press the Enter key, it doesn’t make a break though.

Enter text in a cell

Enter text

Text is entered in a cell.

Select where you want to make a break

Move the cursor to where you want to insert a break.

Press Enter key

Try to press enter key

When Enter key is pressed, a cell below is active.

Make a line break within a cell

This is how to make a line break.

Move the cursor

Select where you want to insert a line break

Move the cursor to where you want to insert a break.

Expand formula bar

Expand formula bar

When you make line breaks, you’d better expand the formula bar. Click the ▼ on the right end of formula bar.

After expanding formula bar

Formula bar is expanded.

Make a line break by using Alt key

insert a line break inside a cell

Press Enter key and Alt key at the same time.

After a line break is inserted

Line break is inserted.

Adjust cell width and height

Change the width and height of the cell.

How to insert a line break with CHAR function

When concatenate cell A1 and cell B1, you can insert a line break with a function.

The ampersand (&) calculation operator

Concatenate texts

Display concatenated text string in cell C1 with the ampersand (&) concatenation operator. Make sure that Warp Text is active.

Concatenate with “&”

Combine text in A1 and B1 with the ampersand (&).

After concatenation with &

Texts are combined in C1, but a line break isn’t inserted.

Insert a line break with CHAR function

line break with CHAR function

We introduce how to insert a line break with CHAR function. Make sure that Warp text is active.

After entry CHAR function

Add “CHAR(10)” between “&”. “(10)” means LF (line feed).

CHAR関数の改行結果

This function made a line break between A1 and B1, so could make a line break.

Windows10とExcel2016

OS : Windows 10, Software : Excel 2016