Carriage Return Within a Cell - How?

WildAngus

New Member
Joined
Jan 10, 2007
Messages
28
Hi,
I am sure there must be a way of doing this other than cut'n'pasting, but does anybody know how I can force a carriage return (line feed) into a cell in Excel when I am wrapping text?
i.e. when you press return excel takes you into the next cell. I want it to remain in the cell and start a new line.
I'm sure this is easy, but cannot find it in the online help.
Thanks in advance.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,166
control + option + enter (.....I think, been a while since i used a mac)
 

Watch MrExcel Video

Forum statistics

Threads
1,099,137
Messages
5,466,900
Members
406,507
Latest member
donwiss

This Week's Hot Topics

Top