arrow
arrow
arrow
Which of the following shortcut keys is used to select multiple rows of MS-Excel 2019 worksheet which are in a continuous range?
Question

Which of the following shortcut keys is used to select multiple rows of MS-Excel 2019 worksheet which are in a continuous range?

A.

Alt

B.

Enter

C.

Shift

D.

Ctrl + Shift

Correct option is C

In MS Excel 2019, to select multiple continuous rows, you first click on the starting row number, then hold down the Shift key and click on the ending row number. This action selects all rows in the range between the two.

Important Key Points:

  1. Shift is used to select a continuous block—works with rows, columns, and cells.

  2. This method is quick and efficient for selecting large blocks of data.

Knowledge Booster:

  • Alt is typically used for accessing the Ribbon menu, not for selection.

  • Enter is used to confirm cell entries and move downward—does not help in selection.

  • Ctrl + Shift is used for non-contiguous selections or special actions, but alone it’s not used to select a block of rows.

Free Tests

Free
Must Attempt

Rajasthan GK Subject Test :03

languageIcon English
  • pdpQsnIcon10 Questions
  • pdpsheetsIcon10 Marks
  • timerIcon8 Mins
languageIcon English
Free
Must Attempt

RRB NTPC UG Level PYP (Held on 7 Aug 2025 S1)

languageIcon English
  • pdpQsnIcon100 Questions
  • pdpsheetsIcon100 Marks
  • timerIcon90 Mins
languageIcon English
Free
Must Attempt

General Awareness Subject Test :01

languageIcon English
  • pdpQsnIcon10 Questions
  • pdpsheetsIcon10 Marks
  • timerIcon8 Mins
languageIcon English
test-prime-package

Access ‘Rajasthan PTET’ Mock Tests with

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