Question by  BrandonBrookes (15)

How can I force a hard return in Excel?

I want to create two lines of text in one cell in Excel. How can I do that?


Answer by  manderso (88)

Move the cursor to the place in the text you want to insert the hard return. Hold down the Alt key and press enter. This will then break the text in the cell across two lines within the same cell. This can be done multiple times (for example, if you wanted to show a list within a single cell).


Answer by  Atomicrayon (2504)

It isn't possible without installing a third party addon. The windows Excel program as it stands is not capable of a "hard return".


Answer by  DreamScaper (354)

The easiest solution is to hit Alt-Return at the end of the first line and that should force a new line in the same cell to have the rest of the data. You may need to adjust the width of the cell to align the lines of text how you want them exactly.


Answer by  Kit (558)

The best way you can do that is by wrapping text. If you have Microsoft Office Excel 2007. Select the cell you want, click the Home tab, under the Alignment group, locate the "Wrap Text" control button. Remember to resize the column width, for the text to fit well.


Answer by  Quual (161)

Select the cell Type in the first line of text Hit Ctrl-Enter (< inserts a hard return) Type in 2nd line of text

You have 50 words left!