If you want to insert a new line in an Excel cell, the simplest way is to press: Enter I.e. press the ALT key and while holding this down, press the Enter key. Use Formulas to Insert a New Line You can insert a new line in an Excel cell using the Excel Char function. The new line character is represented by character number 10. Therefore, a new line can be inserted into a cell using the function: CHAR( 10 ) An example is shown below: Formula: A 1 ="John Smith" & CHAR( 10 ) & "3 Carlton Road" Result: A 1 John Smith 3 Carlton Road Excel Wrap Text Option Formatting Cells to Display a New Line If you have entered a new line in a cell but this is not displayed, this may be because the Wrap Text option is not enabled. To enable the Wrap Text option: Right click on your cell and select Format Cells... From the Format Cells window, select the Alignment tab Tick the Wrap Text option and click OK For more information on the Wrap Text option, see the Wrap-Text-In-Excel page.