![Shift Shift](https://exceljet.net/sites/default/files/images/shortcuts/animations/Extend-last-cell-down.gif)
. 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.
Keyboard shortcuts in Excel 2016 for Mac Excel 2016 for Mac keyboard shortcuts are listed here. If you use Excel on a Windows computer, many of the shortcuts that use the CTRL key also work in Excel 2016 for Mac. However, not all do. When in doubt, consult this list. Some function key shortcuts conflict with default key assignments in Mac OS X version 10.3 or later. To use them, you must change the settings for your function keys. On the Apple menu, go to System Preferences.
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.