How Do I Carriage Return Excel Manuals Like The

I was just having a laugh with my Dad the other day about how spreadsheets are what turned the PC from a toy to a business tool.

On Windows, you can just hit alt-return (or maybe alt-enter; if one doesnt work, try the other).

I was searching the help section and amazingly enough I didnt find anything.

Though it did give me yet another chance to practice my Port Town Poetry on Excel.

I agree that this is a poor shortcut, and poorly documented.

I finally decided to look for a solution and here you are helping to make me just a little less crazy.

Most of the subtitles have 2 lines, which are separated with this character: In Word (Windows or Mac), I can easily replace all the with a line break (p).

How can I do it in Excel for Mac Is there a way to represent the line break within the Excel Replace tool, just like p in the Word Replace tool Or is there a way to paste a Word table (which has line breaks within the table cells) into Excel, keeping the line breaks Thanks Enrique.

When I googled help your instruction was the first thing that popped up:) love when its that easy.

This little nugget of help was brilliant in the simple way it was written.

Thanks.

And big thanks to whoever it was pointed out the MacBook keyboard variation.

Found CTRLOPTION and Option-Command combined with return key or enter key on the extended wired Apple keyboard both work for me in Excel.

Trying to figure these things out sometimes takes so much time and being new to Macs appreciate the tip.

Good job. Michael.

Looks to me like they both work; ie, COMMAND-option-enter OR CONTROL-option-enter.

I just tried putting the cursor at the beginning the next line and hitting delete, and that seems to work.

If you want to have a list of words on one line then youll probably be either using a single cell without linebreaks or multiple consecutive cells.

Any recommendations or advice would be greatly appreciated.

Cheers.

Thank you for taking the time to share.And, you were at the very top of the Google search results.

You just saved me from wasting another 40 frustrating minutes trying to figure this out on deadline May blessings rain upon you.

Ive been using Excel for years and this has always frustrated me beyond belief.

Doing this the old Microsoft way in the top part of the screen (the formula bar) where you can see whats in the cell.

For example, if you enter a formula c5d5 in a cell, the cell itself will show you the result of the formula but the formula bar will show the actual formula.

You used to be able to put a line break while youre in the formula bar but with Excel for Mac, you have to be in the cell itself for the OptionCommandEnter to insert a line break.

How Do I Carriage Return Excel Manuals Like The

I wish Microsoft produced printed manuals like the old days but I guess Googling is still faster:).

How Do I Carriage Return Excel For Mac