Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Start a New Line in Excel

Date:2019-7-2 Author:Cordelia

When you input too much content in a single cell, the text will slop over the borders and affect the layout of your whole table in Excel. The best way to solve this problem is inserting a line break and starting a new line in cell. There’re 2 common methods to achieve it.

How to Start a New Line in Excel

1. Manually

Put your cursor where you want to insert a line break, then press Alt+Enter.

How to Start a New Line in Excel

Now the content behind the cursor has been distributed to a new line.

How to Start a New Line in Excel

2. Automatically

If you don’t want to repeat the same process in every cell, try make it work automatically.

Right click any blank cell, choose Format Cells.

How to Start a New Line in Excel

Click Alignment, select Wrap text in Text control and click OK to enable it.

How to Start a New Line in Excel

Now check the result. When you input too many words to fit in the size of cell, it will insert a line break automatically.

How to Start a New Line in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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