Excel For Mac Carriage Return In Cell

How do you enter a carriage return or CHAR(13) in a worksheet cell manually? I'm not talking about a line feed or CHAR(10). I've seen this in a file and the carriage return had a very weird effect on the cell contents, but I can't reproduce it manually. UPDATE There are very good answers about how to enter a line feed in an Excel worksheet cell, and actually one of them gave me an idea how to achieve what I wanted in the first place: =A1&CHAR(13)&A2 'Then copy cell + paste values only back again. I'll accept the one that updates their content to reflect this. However, it'd be nice to know whether there's an equivalent of Alt + Return to type a carriage return.

The answer is to use Control+Option+Enter, which will create a line break in the cell. As an alternative, Control+Command+Enter can also be used to achieve the same. These combinations work both in Excel for Mac 2011 and the new Excel for Mac 2015. But it also allows you to force line-breaks within cells or merged cells. If you want to create the equivalent of a carriage return within an Excel cell, hit ALT+Enter. The cursor will stay within the cell being edited, but will drop to the next line.

Found: Method 1 - Cell Wrapping Often you only need to set the cell to wrap text, and you can set the width of the cell to whatever is desired. Choose Format Cells, Alignment tab, and check Wrap text.

The result is: Method 2 - Insert a Return This one's a no-brainer. Just type the first line, hit Alt + Enter and type the second line. The result is virtually the same as above, however, if you copy and paste this to Word, for instance, you'll end up with a line break. Or if you export to CSV or other text format, you may get unexpected results.

The result will be: Method 3 - Using a Formula To use this, you must have wrap text selected. Here's a sample formula: =A1 & char(13) & A2 Then copy the cell and paste the values only back again. The results, again, are the same as above. However, if you forget to wrap text on the cell, you'll see this.

Posted:, 02:25 PM In article, JE McGimpsey wrote: > In article, > J Laroche wrote: > > > Use Option-Command (or Alt-Apple) to break the lines. > > and make sure the wrap text option is checked. 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.:) -- Sandy my ISP is earthlink.net -- put sfoster1(at) in front. Posted:, 06:30 PM In article, James Bailey wrote: > 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) 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.

Usually, the choice between getting a free product or buying one is obvious. 100% free vpn for mac.