Input line break in a cell – ALT ENTER

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.

Excel Tips - Line Break

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

In A1:Excel Tips - Line break 1

In C1: Excel Tips - Line break 2

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

Excel Tips - Line break 3

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


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.