How to Enter in Google Sheets | Scribe

    How to Enter in Google Sheets

    • Alai Umerez |
    • 6 steps |
    • 12 seconds

      How to Insert Line Breaks in Google Sheets Using Keyboard Shortcuts

      1
      Double-click the cell to activate it and place the cursor at the point where you want the line break
      2
      For Mac, press [[Command]] + [[Enter]] For Windows, press [[Alt]] + [[Enter]]

      How to Insert Line Breaks in Google Sheets Using the CHAR Function

      information ordinal icon
      Understanding the Formula: The **CHAR(10)** function inserts a line break in a formula\ **Example**: `=A1 & CHAR(10) & B1` combines the text in cells A1 and B1, separated by a line break
      3
      Select the cell where you want the line breaks
      4
      To combine text from two cells with a line break in between, type in the cell you want the result to appear, the char formula "**=Cell 1 & CHAR(10) & Cell 2**" For this specific example, the formula is **=C3 & CHAR(10) & D3**
      5
      Press [[Enter]]
      6
      Review the results