In Excel’s "Edit Mode," which keyboard shortcut allows you to insert a manual line break within a single cell to manage long text…

Question

In Excel’s "Edit Mode," which keyboard shortcut allows you to insert a manual line break within a single cell to manage long text strings or multi-line formulas?

1. A. Tab + Enter
2. B. Ctrl + Enter
3. C. Shift + Enter
4. D. Alt + Enter (Correct answer)

Correct Answer

Option D — Alt + Enter

Detailed Solution & Explanation

The correct answer is Alt + Enter.

Key Points

• Alt + Enter inserts a manual line break inside a cell, letting text wrap onto a new line within the same cell while remaining in edit mode.
• The others do different things:
  • Enter alone confirms the entry and moves to the cell below
  • Ctrl + Enter fills the entire selected range with the same entry
  • Shift + Enter confirms and moves up one cell
  • Tab confirms and moves right

Additional Information

• Alt + Enter also switches on Wrap Text for that cell automatically, so the added lines are visible without further formatting.
• Related editing shortcuts: F2 to edit the active cell in place, Ctrl + ; to insert the current date, Ctrl + Shift + ; for the time, and Ctrl + D / Ctrl + R to fill down or right.
• F4 toggles absolute and relative references while editing a formula — among the most useful Excel shortcuts.
• In Word, by contrast, Shift + Enter inserts a line break within a paragraph, a difference between the applications that is frequently tested.