arrow
arrow
arrow
Which of the following keyboard shortcuts is used to enter a new line in the same cell in a worksheet in MS-Excel 2010?
Question

Which of the following keyboard shortcuts is used to enter a new line in the same cell in a worksheet in MS-Excel 2010?

A.

Tab + Enter

B.

Ctrl + Enter

C.

Shift + Enter

D.

Alt + Enter

Correct option is D

·   Alt + Enter: When working within a cell in Excel, pressing Alt + Enter allows you to insert a line break, creating a new line of text within the same cell. This is particularly useful when you want to format text or numbers within a cell to be more readable.

·   Tab + Enter: The Tab key is used to move to the next cell to the right, while Enter moves to the cell below. Together, they do not perform the function of entering a new line within the same cell.

·   Ctrl + Enter: This shortcut is used to fill the selected cell range with the same data or formula you just entered in the active cell. It does not insert a new line within a cell.

·   Shift + Enter: Shift + Enter is used to move the cursor up one cell in the current selection. It is a navigation shortcut and does not affect line breaks within a cell.

Free Tests

Free
Must Attempt

SSC GD PYP (Held on 4 Feb 2025 S1)

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
Free
Must Attempt

Hindi Section Test 1

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon40 Marks
  • timerIcon12 Mins
languageIcon English
Free
Must Attempt

SSC GD Constable Full Mock Test 1

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
test-prime-package

Access ‘SSC CHSL Tier II’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
353k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow