How to get a line break in Excel 2021, 2019, 2016, 2010, 2007, 2003 quickly

How to get a line break in Excel 2021, 2019, 2016, 2010, 2007, 2003 quickly


The newline in Word is very simple, but the way to return the line in Excel is different, requiring you to master the trick. So how to do line breaks in Excel?

Line breaks in Excel, the problem seems simple but not until you try and realize. If line breaks in Word only need to be done through a few basic keyboard shortcuts, Excel is not so simple. Excel has a tabular working interface and to perform the line break we need a more suitable way. If you are an advanced user, please refer to You guys to learn more about Newline function in Excel here

How to break a line in Excel 2019 and earlier

Instructions on how to break lines in Excel

Note how the newline in Excel applies to all Excel versions from Excel 2007, 2010, 2013, 2016 and the latest here is Excel 2019 with the same way.

Assuming a situation where we have an example that needs to split 3 lines as below, how to split lines 1, 2 and 3 to the bottom. Of course, applying Shift + Enter or Ctrl + Enter will not be possible with Excel.

How to do it in excel

Step 1: The first thing you need to do is click at the end of the line, ie after that position will be newline. Here we choose right after the dot.

How to do it in excel

Step 2: Next you use the key combination Alt + Enter immediately possible newline in Excel.

– Hold the first Alt and then press Enter to perform a line break in Excel.
– Use the left Alt button of your keyboard, the right Alt button has absolutely no effect.

how to do it in excel

Step 3: Applying with the remaining lines we will get 3 completely separate lines from each other, this is the simplest way to break a line in Excel.

How to do it in excel

Actually with Excel we can use the newline command in Excel but it is extremely complicated and inconvenient. Use the key combination Alt + Enter It’s a quick and easy solution.

Through’s article on how to enter lines in Excel, you see, Excel’s tricks are many but extremely simple. It’s not difficult to figure it all out, but it does take time. To save time studying Excel tricks interesting and useful, is the place that you need to visit often.

You can also refer to how to create insurance in Excel here to use when needed.

See also: How to create a table in Excel
In Excel to use proficiently in the fastest way, users need to know Excel shortcuts, Excel keyboard shortcuts help us save time when using for work. Please take note of this.

Related keywords:

done in Excel

scrolling in Excel, Autoline in Excel,

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: