create two lines in one cell

  • Thread starter Thread starter garrett
  • Start date Start date
G

garrett

I want to create a second line within one cell so gthat the print within the
cell will wrap at a requested position. The end result would look like this
for one cell:

HERTZ -
7 day car rental
 
Use ALT_ENTER. The wrap only shows after your entry is finished

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I want to create a second line within one cell so gthat the print within the
| cell will wrap at a requested position. The end result would look like this
| for one cell:
|
| HERTZ -
| 7 day car rental
 
Thank you, I wasn't able to find that info in the Exel database. I tested it
and it works on my Exel 2003.
 
Help>Multiple lines reveals this info....

Display multiple lines of text within a cell
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.

Tip

To start a new line of text at a specific point, click where you want to break
the line, and then press ALT+ENTER.



Gord Dibben MS Excel MVP
 
Back
Top