Line Break not working in cell any suggestions

bostoncrusader

New Member
Joined
Feb 24, 2010
Messages
5
Hello,

I am trying to Learn how to use line breaks and text wrapping to create a single cell that contains two lines of text. I found out that you use ALT+Enter, but it is not working. Any suggestions? I am using 2007.

Kind regards,
Trisha :)
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

btadams

Well-known Member
Joined
Jan 6, 2003
Messages
1,936
Welcome to the board!

Alt + Enter should create a new line within a cell in Excel 2007. If you start typing some text into a cell then press Alt + Enter it should move to a new line within the cell.
 

bostoncrusader

New Member
Joined
Feb 24, 2010
Messages
5
Hi btadams,

Thank you but it still did not work. My coworker just found this solution and it works: control, option, return

Thanks,
Trisha

P.S. I also forgot to mention we are on macs..:rolleyes:
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,831
Office Version
  1. 365
Platform
  1. Windows
Trisha

This might be a strange question, but why are you trying to learn how to do this.

Having 2 separate pieces of data in one cell is not a good idea.

Next thing you'll be wanting to look into merged cells.:)
 

bostoncrusader

New Member
Joined
Feb 24, 2010
Messages
5

ADVERTISEMENT

Hi Noire,

My co-worker wants to use this option in her headings.

Thanks,
Trisha
 

Watch MrExcel Video

Forum statistics

Threads
1,108,974
Messages
5,525,990
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top