Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - Can I have a rowbreak in a cell with wrap text? 1

Status
Not open for further replies.

GrodanBoll

Programmer
Mar 6, 2002
45
ZA
Hi

I'm about to create a time rapport for my work.
In a cell I'd like to write a desciption for the hours. But in this description I'd sometimes like to have a row break to make my description easier to read.
I've tried SHIFT + RETURN but it doesn't work.

Can I do this?

Thanks :)
Grodan
 
Right click the cell, select "Format cells...", then go to Alignment tab, check the "wrap text" option. click ok.
 
Hi,

If I understand your question correctly, what you need to do is 'Alt + Return' which forces a new line within a cell.

Cheers,

Jock
 
Thx Jock1970. :)
That was the answer I was looking for.

Sry trqchina if my post was diffuse.

/Grodan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top