how to add multiple rows in excel at one time

Select the cells you want to remove multi lines from, and click Kutools > Text > Remove Characters. If you want to remove all multi lines from cells, you can try the Remove Characters utility of Kutools for Excel.īefore applying Kutools for Excel, please download and install it firstly.ġ. With this shortcut key, you can split the cell contents into multiple lines at any position as you need.Įasily remove all multiple lines from selected cells with Kutools for Excel Pressing the Alt + Enter keys simultaneously helps you separate texts with different lines in one cell. You can put multiple lines in a cell with pressing Alt + Enter keys simultaneously while entering texts. Put multiple lines of text in one cell with pressing Alt + Enter keys See the below demo.ģ0-day free trail of Kutools for Excel now!

If you want to remove all line breaks from specific cells, the Remove Characters utility of Kutools for Excelcan do you a favor. Easily remove all line breaks from selected cells in Excel:

How to add multiple rows in excel at one time