Suppose you have a dataset as shown below where there are addresses that have a comma separating parts of it. But with large datasets, you can also use the help of a simple formula. Using the keyboard shortcut to get to a new line is fine if you’re manually entering the data. Replace a Character with Line Break in Google Sheets The above steps would add a new line and you will see the cursor in the next line.
ALT + ENTER (hold the alt key and then press the Enter key)īelow are the steps to use this in a cell to go to a new line: If you’re manually entering data in Google Sheets, you can use the below keyboard shortcut to add a new line in the same cell.
Manually add a new line in the same cell (Keyboard Shortcut) Replace a Character with Line Break in Google Sheets.
