Carriage return within a cell

S

Sandy Foster

I'm stumped. How is it possible (or *is* it possible) to put a carriage
return inside a cell? What I want to know is how to make a second line
in a cell, but without it doing so by means of automatic wrapping. I
want to break the line where *I* want it. Is there a way to do this?
Thanks!
 
J

J Laroche

Sandy Foster wrote on 2005/06/09 21:16:
I'm stumped. How is it possible (or *is* it possible) to put a carriage
return inside a cell? What I want to know is how to make a second line
in a cell, but without it doing so by means of automatic wrapping. I
want to break the line where *I* want it. Is there a way to do this?
Thanks!
Click to expand...

Use Option-Command (or Alt-Apple) to break the lines.

JL
Mac OS X 10.3.9, Office v.X 10.1.6
 
S

Sandy Foster

JE McGimpsey said:
and make sure the wrap text option is checked.
Click to expand...


Thanks to both of you! For some reason, this wasn't working when I tried
it on cells I'd already filled. But when I tried it on a newly-filled
cell, it did. Thanks again. :)
 
J

J Laroche

JE McGimpsey wrote on 2005/06/10 00:45:
and make sure the wrap text option is checked.
Click to expand...

The option gets checked by itself, so it's not necessary to do it manually
unless it's been removed afterwards.

JL
Mac OS X 10.3.9, Office v.X 10.1.6
 
J

JE McGimpsey

J Laroche said:
The option gets checked by itself, so it's not necessary to do it manually
unless it's been removed afterwards.
Click to expand...

True, I didn't mean to imply otherwise.

Since it's a "silent" format change, however, and linewrap and a manual
line break aren't necessarily intuitively connected, I've seen more than
a few users confused when their line breaks disappear.
 
P

phil

Hi:
is it possible (or *is* it possible) to put a carriage
return inside a cell? [...] how to make a second line
Click to expand...

As others have mentioned just press [Alt][Enter] to manually add a line
break.

If however you need to import HTML files into Excel and you want to
preserve the line-breaks generated by the <BR> tags then you need to
make sure your HTML file contains some special style sheet code. Here
is an example:

<html>
<head>
<style>
<!--table
br
{mso-data-placement:same-cell;}
-->
</style>
</head>
<body>
<table>
<tr>
<td>
This will be on line one<br>
This will be on line two<br>
This will be on line three<br>
This will be on line four<br>
</td>
</tr>
</table>
</body>
</html>

Without the style sheet codes each line would be on a separate row.

Cheers,

Phil
 
J

James Bailey

Or, if you're on a standard Mac keyboard that doesn't have a proper "alt"
key, you have to copy and paste a shift+return from a word processor (i.e.,
word)


Hi:
is it possible (or *is* it possible) to put a carriage
return inside a cell? [...] how to make a second line
Click to expand...

As others have mentioned just press [Alt][Enter] to manually add a line
break.

If however you need to import HTML files into Excel and you want to
preserve the line-breaks generated by the <BR> tags then you need to
make sure your HTML file contains some special style sheet code. Here
is an example:

<html>
<head>
<style>
<!--table
br
{mso-data-placement:same-cell;}
-->
</style>
</head>
<body>
<table>
<tr>
<td>
This will be on line one<br>
This will be on line two<br>
This will be on line three<br>
This will be on line four<br>
</td>
</tr>
</table>
</body>
</html>

Without the style sheet codes each line would be on a separate row.

Cheers,

Phil
Click to expand...
 
J

JE McGimpsey

James Bailey <[email protected]> said:
Or, if you're on a standard Mac keyboard that doesn't have a proper "alt"
key, you have to copy and paste a shift+return from a word processor (i.e.,
word)
Click to expand...

What "standard Mac keyboard" doesn't have an Option/Alt key? Older
keyboards were labeled "option", both my laptop and desktop keyboards
have a dual label, "option" and "alt". Or am I misunderstanding...

IIRC, CMD-OPT-RETURN has worked for at least the last 4 versions...
 
J

James Bailey

Well, every keyboard I've ever had has the option key with the little alt on
it as well, but no amount of option-enter has ever produced a soft-return
for me in any program on my Macs. Maybe it's me.
 
P

Paul Berkowitz

You have to include the Command (Apple) key, as JE said.

CMD-OPT-RETURN and CMD-OPT-ENTER both work.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
 
J

JE McGimpsey

James Bailey <[email protected]> said:
See. I never knew that
Click to expand...

Take a gander at Help ("Keyboard shortcuts") - that shortcut (well, it's
CTRL-OPT-RETURN variant, but both work) has been in Help since at least
XL98. There may be others you can use.
 
B

Bernard Rey

James said:
See. I never knew that, and Phil posted:
As others have mentioned just press [Alt][Enter] to manually add a
line break.
Click to expand...
Click to expand...
Which won't work.
Click to expand...

This "[Alt][Enter]" tip has most probably been given by a Windows users, as
this is the way it works on the Windows side.

On the Mac side, as mentioned hereunder, you have to add the Command (Apple)
Key. And this is the way it has been for some time now :)
 

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

Replacing a phrase with carriage returns 1
Request help determining line length and end of line carriage returnsthrough document 0
Outlook calendar list 0
Excel does not accept text format! 0
Enter carriage return in Excel 2010 text string 2
Find 'carriage return' in field 2
Word macro that can call cells out of Excel for a find and replace 0
Hard carriage return at the end of cell 2

Top