How to add space inside a cell in Excel?

If you want text to appear on multiple lines in a cell, you can format the cell so that text wraps automatically, or you can enter a manual line break.

  1. Wrap text automatically

    • Select the cells you want to format.
    • On the Format menu, click Cells, and then click the Alignment tab.
    • Under Text control, select the Wrap text check box, and then click OK.

    Note: Data in the cell will wrap to fit the column width. When you change the column width, data wrapping adjusts automatically.

  2. Enter a line break

    • To start a new line of text at a specific point in a cell, click where you want to break the line, and then press ALT+ENTER.

    Note: If all wrapped text is not visible, it may be because the row is set to a specific height. To allow the row to adjust automatically and show all wrapped text, point to Row on the Format menu, and then click AutoFit.

Source: MS Office Excel Help and How to - Wrap text in a cell