Solved

Line break (return) in Excel 2011 Mac

Posted on 2011-03-09
6
1,581 Views
Last Modified: 2012-08-13
Hi Experts,

I'm wondering if it is possible to put a line break in a piece of text which resides in an Excel (2011, Mac) cell. Usually after a line break, the text continues in the cell (or new cell) below.
Is this possible and if so, how do you do that? Is there an escape-character or a workaround? I want to test this for a mail merge document I'm experimenting with.

Thanks!
0
Comment
Question by:Mac2010
6 Comments
 
LVL 1

Expert Comment

by:kavik379
ID: 35087076
Did you try Shift-Enter?
0
 
LVL 8

Author Comment

by:Mac2010
ID: 35087090
I think so. If that is the soft line break, I have.
0
 
LVL 9

Expert Comment

by:McOz
ID: 35087098
use alt+enter in a cell for a soft return.

Cheers
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 8

Author Comment

by:Mac2010
ID: 35087169
OK, thanks. I will test the suggestions (and get back at it) later since Excel 11 is not installed on the Mac I'm working on now.
0
 
LVL 8

Accepted Solution

by:
et01267 earned 250 total points
ID: 35087247
Actually, I think it is Command-Option Enter (verified on Excel 2011).
0
 
LVL 8

Author Closing Comment

by:Mac2010
ID: 35095830
Works for me too. Exactly what I was looking for!
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There is a security feature on iOS devices that is nearly impenetrable when it has been activated.  This article will provide some possible solutions as well as necessary steps to take to ensure you do not end up with a locked device.
In this article we have discussed about the OS X EI Capitan and how to fix Wi-Fi issue in OS X El Capitan. We have explained how to delete system level preferences and create a new Wi-Fi location to resolve Wi-Fi issue.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question