How to move cursor in a cell in Excel

How to move down a line in a cell within Microsoft ExcelUpdated: 12/31/2020 by Computer HopeIn Microsoft Excel, the default action when pressing the Enter key is to move down to th

How to move cursor in a cell in Excel

How to move down a line in a cell within Microsoft ExcelUpdated: 12/31/2020 by Computer Hope

Microsoft Excel Move down a line keyboard shortcut

In Microsoft Excel, the default action when pressing the Enter key is to move down to the next cell. However, when working with a cell containing multiple lines of text, it can be frustrating to create a new line. Below are the keyboard shortcut keys to make this task easy.

  • All latest versions of Microsoft Excel.
  • Microsoft Excel in Windows.
  • Early versions of Microsoft Excel for the Mac.

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 text in the cell. When ready for a new line, press and hold down the Alt key, then press the Enter key. The shortcut key can be used as many times as needed.Note

If you are on a Mac and the key shortcut above doesn't work, try Control+Option+Return.Tip

Instead of adding a note or lots of text in a cell, create a comment to make the spreadsheet look cleaner. For help creating a comment, see: How to create, edit, and delete a comment in Microsoft Excel.

Microsoft Excel in Windows

On all versions of Microsoft Excel for the PC and Windows, the keyboard shortcut Alt+Enter moves to the next line. To use this keyboard shortcut, type text in the cell and when ready for a new line, press and hold down the Alt key, then press the Enter key. The shortcut key can be used as many times as needed.Tip

Instead of adding a note or lots of text in a cell, create a comment to make the spreadsheet look cleaner. For help creating a comment, see: How to create, edit, and delete a comment in Microsoft Excel.

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 text in the cell and when ready for a new line, press and hold down the Control key, Option key, and Return key. The shortcut key can be used as many times as needed.Tip

Instead of adding a note or lots of text in a cell, create a comment to make the spreadsheet look cleaner. For help creating a comment, see: How to create, edit, and delete a comment in Microsoft Excel.

  • How to start new line in a spreadsheet cell.
  • All Microsoft Excel keyboard shortcuts.
  • See our cell and new line definitions for further information and related links.
  • Microsoft Excel help and support.

Video liên quan