![]() ![]() Insert Excel Carriage Return by using Formula It has inserted the carriage return character to push the data to the new line within the same cell. Next again, we will press the shortcut key ALT + ENTER. ![]() Now again, place a cursor in front of the third-line data.Pressing the “ALT + ENTER” key pushes the content in front of the selected data to the new line by inserting a carriage return. We will press the excel shortcut key ALT + ENTER to insert the carriage return character in the Excel cell.We will place a cursor before the content, which we must push to the next line.First, our data looks like this in a cell. Ok, let’s get back to this and see how we can insert a carriage return.As you can see above, it has reduced the row’s width and increased its height by placing a carriage return character.So, in this case, we need to push the second line to the next line and the third line to the next line, like the one below. We have three sentences in cell A1, separating each by a comma (,). For example, let us look at the below data set.
0 Comments
Leave a Reply. |