Question

How will you enter a new line in the same cell in the Microsoft Excel sheet?
1. By Pressing "Enter"
2. By pressing "shift + Enter"
3. By pressing "Alt + Enter"
4. By pressing "Tab"

Answer 1

Correct Answer - Option 3 : By pressing "Alt + Enter"

The correct answer is By pressing "Alt + Enter".

• Alt+Enter is a keyboard shortcut most often used to create a new line in a Microsoft Excel cell.

• The Enter key sends the cursor to the beginning of the next line or executes a command or operation.  
• By using Shift-Enter, one can remove the gap between each line.
  • This is also very useful when creating a bulleted or numbered list. Pressing Shift-Enter allows us to go to the next line without creating a new bullet or number. 
• Pressing the tab key would advance the carriage to the next tabulator stop.