Advertisement

How To

Excel trick: How to write a lot of text in a single cell

Mike Braun

Mike Braun

  • Updated:

Excel is not designed for text. When you write long sentences, the program shows all the text on the same line, even if it is very long, although it really is only in a single cell.

In some tables, performing a line break inside a cell allows for a clearer visualization. This isn’t necessarily the best option design-wise.

Excel trick: How to write a lot of text in a single cell
  1. Click on the cell where you want to write a lot of text

    Click on the cell where you want to write several lines and, before pressing “Enter,” keep the Alt key pressed.

  2. Repeat step one to add height to the cell

    Keep pressing Enter while holding down the Alt key. The more times you hit Enter, the higher the cell will be.

  3. Resize the height of the cell

Mike Braun

Mike Braun

Mike Braun is a technology editor for Softonic. He spent his childhood being frustrated by Battletoads, then moved on to being frustrated by that lava level in Aladdin for Sega Genesis. A graduate of Florida State University, he now lives in Portland where he's working on a science fiction novel series and drinking too much coffee.

Latest from Mike Braun