How Do You Get Text to Go on More Than One Line of a Cell in Excel?


To enter more than 1 line of text within a cell, within the formula bar - select 'Alt & Enter' where you want the additional lines to show. Also, I wasn't clear on the question if 'wrapping text' would solve your issue. If so, right click on cell, click on Format, then the 'alignment' tab and click on 'Wrap text'.
Q&A Related to "How Do You Get Text to Go on More Than One Line..."
Place your cursor where you want the line to end and next line to begin. If the data that you want to split in 2 (or more) line is already entered in the cell, you can place your
Go to the Format menu, pick Cells and Alignment and the click the Wrap Text option.
Press ALT+ENTER to enter a line feed in a cell. Kevin
When typing in a cell within an Excel worksheet, press
Explore this Topic
I use excel all the time but it does have it's limits. A cell can contain 32,767 characters BUT only 1,024 will actually be displayed in the cell. All the characters ...
If you want to repeat the contents of a cell somewhere else and have it update automatically, you can use an equals formula. For example, if you wanted to copy ...
1. Start Microsoft Excel and open the file you want to change. 2. Select the cells in which you want to align the text. 3. Open the Format menu and select Cells. ...
About -  Privacy -  AskEraser  -  Careers -  Ask Blog -  Mobile -  Help -  Feedback © 2014