how do i form 2 lines in 1 row?

R

Ron Coderre

I'm guessing you're looking to force text in a cell to wrap into the next
line of the same cell.

If that's true......
Edit the text and move the insertion point to where you want to wrap the
text.
Hold down the [Alt] key and press [Enter]

Does that help?
----------------------------------

Regards,

Ron
Microsoft MVP (Excel)
 
G

Gord Dibben

In one cell type this is line one then Alt + ENTER then type this is line
two.

The Alt + ENTER gives you a carriage return in the cell.


Gord Dibben MS Excel MVP
 

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

How do I format line return in a cell? 2
In Excel how do I force text into next line before first is full? 8
Automatically moving to next row in a table 1
Controlling word wrap in a cell 2
finding where text wraps in a textbox 4
Text in merged cells is spilling over 3
Multiple Lines in One Cell 2
Forced new line in a cell: Excel 2

Top