new line within a cell

J

Jeff

Hi

In Excel 2002 or 2007, I need to enter several lines into a single cell.

What I mean is I need the capability to tell Excel to enter the next
line of text as a new line within that cell. Is that possible?

Obviously Enter does not work because it accepts the entry and goes to
the next cell.

Thanks.

Jeff
 
G

Gord Dibben

Type some text in a cell

Alt + Enter

Type some more text in same cell

Alt + Enter

Type a third line in the cell

Enter to leave cell.


Gord Dibben MS Excel MVP
 
J

Jeff

Thank you.

Jeff

Type some text in a cell

Alt + Enter

Type some more text in same cell

Alt + Enter

Type a third line in the cell

Enter to leave cell.


Gord Dibben MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing line height within a cell ? 3
Word Removing unwanted "lines" within a MS Word 10 table 1
Removing unwanted "lines" within a MS Word 10 table 2
Forced new line in a cell: Excel 2
Splitting up multiple lines in one cell to one line per cell inmultiple cells 5
Starting a new line 2
multiple lines in a cell 4
Date function within loan amortization spreadsheets 3

Top