Ad
Sponsored by Sir Tauqeer
CLICK HERE TO JOIN SIR TAUQUEER WHATSAPP GROUP
FOR PREPARATION CLASSES AND JOBS UPDATES
Join Now

Which keyboard shortcut is used to extend the selection down in a Microsoft Excel worksheet?

A. Shift + Down Arrow
B. Ctrl + Shift + Right Arrow
C. Alt + Down Arrow
D. Ctrl + Down Arrow
Correct Answer: A. Shift + Down Arrow

In Microsoft Excel, extending a selection involves using the Shift key in combination with arrow keys. This allows users to quickly select a range of cells.

  • Shift + Down Arrow is the correct shortcut to extend the current selection downwards by one cell. Holding Shift while pressing an arrow key extends the selection in that direction.
  • Ctrl + Shift + Right Arrow extends the selection to the last non-empty cell to the right.
  • Alt + Down Arrow is often used to open drop-down lists or filter menus.
  • Ctrl + Down Arrow moves the active cell to the last non-empty cell in the current column downwards, without extending the selection.

Leave a Comment

Join Our WhatsApp Channel ×
Scroll to Top