Input line break in a cell – ALT ENTER

Input line break in a cell – ALT ENTER

by MF

In Word, it is so simple to input a line break by pressing Enter.  However in Excel, pressing Enter will take you to the cell below.

To input line break in Excel requires just a simple key combination.  What you need is to press the ALT and ENTER keys together.  Yes.  It is as simple as that.

Btw, there are always unexpected way of doing that in workplace.  Take a look at the screenshot below.

They looks like the same? but input in different ways:

In A1:

In C1: 

When the column width is changed, they no longer look the same.

Can you tell which one is the proper way now?

Note: Wrap Text is turned on automatically when you input line break by pressing ALT ENTER

#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1