How to add space inside of a cell in Excel?

Question

How would I add space inside a cell in Excel?

I'm using MS 2007 as shown here:

Answer 1

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