View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default create two lines in one cell

HelpMultiple 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

On Sat, 26 Jan 2008 03:06:02 -0800, garrett
wrote:

Thank you very much. I could not find that info anywhere!

"Mike H" wrote:

Type

HERTZ -
Click Alt+Enter
Type your second line of text

Mike

"garrett" wrote:

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