Discussion
In MS Excel, which shortcut moves to the last cell containing data in the current region, downwards?
Answer: B
Correct answer: Ctrl + Down Arrow
Ctrl + Down Arrow jumps to the last filled cell of the contiguous block below the cursor, and stops at the edge of any gap. From an empty cell it jumps to the next filled one, or to the bottom of the sheet if there is none. The same works in all four directions, and adding Shift selects everything passed over - so Ctrl + Shift + Down selects a whole column of data in one keystroke, which is the fastest way to select a long range. Ctrl + End, the fourth option, is different: it goes to the last used cell of the whole sheet, the intersection of the last used row and column. That is often further out than the visible data, because Excel remembers cells that once held content - and that stale boundary is what inflates file sizes and can be reset by deleting the surplus rows and columns and saving. Alt + Down opens a drop-down list in the cell.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development