Tuesday, March 23, 2021

Start a new line of text inside a cell in excel

To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break.

  1. Double-click the cell in which you want to insert a line break.

  2. Click the location inside the selected cell where you want to break the line.

  3. Press Alt+Enter to insert the line break.

To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press CONTROL + OPTION + RETURN to insert a line break.

  1. Double-click the cell in which you want to insert a line break.

  2. Click the location inside the selected cell where you want to break the line.

  3. Press CONTROL+OPTION+RETURN to insert the line break.

To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break.

  1. Double-click the cell in which you want to insert a line break (or select the cell and then press F2).

  2. Click the location inside the selected cell where you want to break the line.

  3. Press Alt+Enter to insert the line break.

  1. Double-tap within the cell.

  2. Tap the place where you want a line break, and then tap the blue cursor.

    Insert line break

  3. Tap New Line in the contextual menu.

    New line

Note: You cannot start a new line of text in Excel for iPhone.

  1. Tap the keyboard toggle button to open the numeric keyboard.

    Keyboard switch

  2. Press and hold the return key to view the line break key, and then drag your finger to that key.

    Line break button

Note: The following procedure applies to Excel Mobile on Windows 10 only.

  1. If you are typing in a cell already, tap any other cell to get out of editing mode.

  2. Stretch two fingers apart to zoom in on a cell.

  3. Double-tap the cell.

  4. Tap and hold the selection handle and then drag it to the place where you want a line break.

    Insert line break

  5. Tap the selection handle Selection handler again.

  6. Tap New Line.

    New line

Tip: If you are using an external keyboard, you can use the shortcut keys Alt+Enter.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

1 comment:

  1. Science has many big remaining questions. To address them, we will need to work collaboratively and across disciplines. The goal of iScience is to help fuel that type of interdisciplinary thinking. iScience is a new open access journal from Cell Press that provides a platform for original research in the life, physical, earth, and health sciences. The primary criterion for publication in iScience is a significant contribution to a relevant field combined with robust results and underlying methodology. The advances appearing in iScience include both fundamental and applied investigations across this interdisciplinary range of topic areas. To support transparency in scientific investigation, we are happy to consider replication studies and papers that describe negative results.
    iScience Impact Factor
    iScience Abbreviation

    ReplyDelete