Jun 24, 2013 - Most users won't ever need to enter a line break in an Excel spreadsheet cell - but if you do - it's not as easy as you might think! Simply hitting. Real Geek Forums > Archives > Operating Systems > Apple Macintosh > Mac Office > Mac Office Excel > Carriage return within a cell Carriage return within a cell Posted:, 01:16 AM.
. All latest versions of Microsoft Excel All versions of Microsoft Excel for the PC and Mac now support the ability to press the keyboard shortcut Alt+Enter to move to the next line.
To use this keyboard shortcut, type the text you want in the cell and, when ready to move to the next text line, press and hold down the, then press the. The shortcut key can be used as many times as needed. Tip: If you need to make a note or have a cell with a lot of text, you may also consider on the cell instead of creating a cell containing multiple lines of text to make the spreadsheet look cleaner.
Note: If you are on a Mac and this does not work, try Control + Option + Return. Microsoft Excel in Windows On all versions of Microsoft Excel for the PC and Windows, the keyboard shortcut Alt+Enter will move to the next line. To use this keyboard shortcut, type the text you want in the cell and, when ready to move to the next text line, press and hold down the, then press the. The shortcut key can be used as many times as needed. Tip: If you need to make a note or have a cell with a lot of text, you may also consider on the cell, instead of creating a cell containing multiple lines of text, to make the spreadsheet look cleaner.
Early versions of Microsoft Excel for the Mac On earlier versions of Excel for the Mac, the Alt+Enter keyboard shortcut does not work. To create a new line on the Mac, use the Control + Option + Return keyboard shortcut. To use this keyboard shortcut, type the text you want in the cell and when ready to move to the next text line, press and hold down the and, then press the. The shortcut key can be used as many times as needed. Tip: If you need to make a note or have a cell with a lot of text, you may also consider on the cell, instead of creating a cell containing multiple lines of text, to make the spreadsheet look cleaner.