Select to the end of the column
An Excel shortcut drill from Shortcutdrill. Solve it with a live sheet in your browser with a limit on key presses, and it is checked the moment you submit.
The task
From C2, select down to the last filled cell in column C.
What this drill teaches
Ctrl+Shift+Down selects to the end of the block. It is how you grab a column of 5,000 values in one press.
A hint if you get stuck
Windows: Ctrl+Shift+Down arrow. Mac: Cmd+Shift+Down arrow. The drill allows 1 key press.
Try it now, no account needed
This drill is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this drill