![]() ![]() If you want to create the equivalent of a carriage return within an Excel cell, hit ALT+Enter. But it also allows you to force line-breaks within cells or merged cells. These combinations work both in Excel for Mac 2011 and the new Excel for Mac 2015. As an alternative, Control+Command+Enter can also be used to achieve the same. ![]() ![]() The answer is to use Control+Option+Enter, which will create a line break in the cell. However, it'd be nice to know whether there's an equivalent of Alt + Return to type a carriage return. I'll accept the one that updates their content to reflect this. 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'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. 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).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |