To enter new line in excel google sheet, place your cursor where you want the current line to end and press Alt + Enter (Windows) or Cmd + Enter (Mac).
A new line in excel cell is inserted when one needs to shift a string to the cell’s subsequent line. To insert a new line, a line break must be be put at the appropriate place. A line break instructs Excel to break the existing line and begin a new line (within the same cell) with the character that comes next. A cell’s content appears in numerous lines when line breaks are added.
Enter New Line Within Cell
Keyboard Shortcut
- Click twice on the cell where you wish to insert a line or select it and then press F2.
- Set the cursor where you wish the line break to appear.
- Press the Enter key while holding down the ALT key.
OR - Iy you are Mac user then Press Ctrl + Option + Enter
With these steps your cursor will move to a new line within the same cell.
Function (Char)
Follow these steps to enter line to your cell:
- Type the formula =char(10) in the cell where you want to enter new line.
- You can add as many CHAR(10) functions to a formula as you wants. That means, adding “& CHAR(10) & CHAR(10) &” to a formula will add 2 line breaks in a row, adding a blank line between paragraphs.
Wrap Text
Apart from the above mentioned methods, you can also enter the line in the cell through Wrap Text.
Make sure that width of cell is same as length of what you want to keep on the first line.
Select the cell, then go to Home-> Format-> Wrapping-> Wrap.
Enter New Line on Android or iOS Mobile App
First of all, you have to go to the cell where you want to insert line break then press Enter key on your phone’s keyboard. You will get the same results as if it is done on computer.