All Exams Test series for 1 year @ ₹349 only
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?

This question was previously asked in
SSC CGL 2025 Tier 2 Paper 1 Question Paper (19-Jan-2026)
The correct answer is

Alt + Enter

While a cell is in Edit Mode, pressing Enter normally confirms the entry and moves the cursor to the next cell, so a special key combination is needed to break the text onto a new line within the same cell.

Alt + Enter inserts a manual line break inside the current cell, letting long text or a multi-line formula wrap onto several lines while still occupying one cell.

This is the standard Excel shortcut for forcing a new line within a cell without ending the edit, which is precisely what the question asks.

Ctrl + Enter enters the same value into every cell in the current selection at once; it does not create a line break inside a single cell.

Shift + Enter confirms the entry and moves the active cell upward to the previous cell, so it also does not add a line break.

Tab + Enter is not a single line-break command: Tab moves the cursor one cell to the right and Enter confirms, so together they do nothing to break a line.

Because only Alt + Enter inserts an in-cell line break, the correct answer is Alt + Enter.

Was this answer helpful?

Similar Questions

  1. Which among the following keyboard shortcut can be used to open Windows Explorer?

  2. Which of the following is keyboard shortcut to reload the current page in Google search engine?

  3. Which among the following keyboard shortcuts open the properties for the selected item on a Windows 10 home screen?

  4. Which among the following keyboard shortcuts is used to bookmark the current webpage on the web browser?
  5. In Windows 10/11, which shortcut key combination allows a user to cycle through apps on the Taskbar in the order they are pinned?


Important Questions from Keyboard Shortcuts

  1. ‘Ctrl + B’ depicts:

  2. Which shortcut key is used for print preview ?

  3. Which of the following shortcut key is used to repeat the last command or action, if possible, in MS-Excel 365?

  4. Which of the following shortcut key is used to start a new line in the same cell in MSExcel 365?

  5. Which among the following keyboard shortcut can be used to open Windows Explorer?

Need Expert Advice?
Upcoming Exams
UPSSSC PET
October 25, 2026
SSC JE
November 02, 2026
SSC CPO
November 20, 2026
SSC CHSL
November 30, 2026
Test Series
SSC CGL img
SSC
SSC CGL (Tier I + Tier II) 2026 Mock Test Series - Latest Pattern
2503 Tests 6 Tests Free
7977 Attempts
4.2(912)
English, Hindi

Start Your Preparation with Prepp Mobile App

Download the app from Google Play & App Store
Download the app from Google Play & App Store
Prepp Mobile App