Subscribe To
This Site

Separate the text into two lines in a cell

To present your report professionally, you need to separate the description into two lines in a cell, i.e. “Total Revenue” in one line and “($ ‘000)” in the second line within the same cell (B5). How would you do it?

One solution used by most excel users is to format the cell with the wrap text option and then adjust the column so that the width is just sufficient to display the description “Total Revenue”. This will cause the text “($ ‘000)” to flow to the next line. This method is not reliable because the presentation will appear that way only in the creator’s computer. If this excel file is to be sent to another person, the word Revenue in the line “Total Revenue” may run off to the next line if the users uses another resolution. Or the text “($” may move to the second line.

In order to ensure that the description is maintained in two different lines under all conditions, we need to insert a line break after the word “Revenue”. This can be done by

1) Edit the cell (Select the cell and press the function key F2 or point the mouse button at the formula bar after the word “Revenue” and click on the left mouse button).

2) Press the button “ALT” together with the “ENTER” key. We have separated the text into two lines in a cell.

footer for two lines in a cell page