For cell with long texts beyond your cell, you can auto adjust the texts into multiple lines for fitting the cell width with formatting the cell as wrap text. Right click the cell you want to put multiple lines, then click Format Cells.
Mar 7, 2013 - As pointed out by Shameer in this answer, Alt + Enter now seems to work as well in the new Excel for Mac 2015. The ⌥ alt key is also the ⌥ option key on a Mac keyboard. Use Alt + Enter. It should solve your problem.
See screenshot: 2. In the Format Cells dialog box, check the Wrap text box under the Alignment tab, and then click the OK button. Note: You can also just click Home Wrap Text to put the overwriting text string to multiple lines. Put multiple lines of text in one cell with pressing Alt + Enter keys You can put multiple lines in a cell with pressing Alt + Enter keys simultaneously while entering texts. Pressing the Alt + Enter keys simultaneously helps you separate texts with different lines in one cell. With this shortcut key, you can split the cell contents into multiple lines at any position as you need.
Easily remove all multiple lines from selected cells with Kutools for Excel If you want to remove all multi lines from cells, you can try the Remove Characters utility of Kutools for Excel.: with more than 300 handy Excel add-ins,. Select the cells you want to remove multi lines from, and click Kutools Text Remove Characters. See screenshot: 2. In the Remove Characters dialog box, only check the Non-printing box, and then click the OK button.
Now all multi lines in selected cells are removed immediately. Tip.If you want to have a free trial of this utility, please go to first, and then go to apply the operation according above steps. Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful:.
![Excel 2008 for mac how do i go to new line within cell in excel Excel 2008 for mac how do i go to new line within cell in excel](/uploads/1/2/5/4/125486918/875311710.png)
Merge Cell/Rows/Columns without Losing Data. Combine and Consolidate Multiple Sheets and Workbooks. Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,. More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.
Posted:, 01:13 PM Command+Option+Return should give you what you're looking for & a search of Excel Help for: shortcuts will provide even more. HTH :) Bob Jones MVP Office:Mac On 3/8/08 8:51 PM, in article 9absDaxw, '[email protected]' wrote: Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel I am a new mac user and used to hitting alt + enter (PC) to go down to the next line within the same cell. I cant seem to figure out how to do this on the mac.
Any help would be greatly appreciated!