Multiple paragraphs of text in an Excel cell sound good, they look good but how the heck do you create them? If you press the Enter key you enter the current text into the cell and move away from it – obviously, pressing the Enter key isn’t the answer.

The solution is to press Alt + Enter to create a new line of text in the current cell. Do this as often as you need to. You might have to make the row taller to fit the text if Excel doesn’t make the adjustment for you.

Helen Bradley

Related posts:

  1. Align data in Excel
  2. Excel 2007 – Now where to?
  3. Excel – Multiply cell values inside the cell
  4. Excel 2007- In Cell Dropdown List
  5. Excel – Sum a cell in all sheets but this one