Shortcutdrill

Level 9: Grouping and structure Drill 79 of 80 Free

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

More drills in Grouping and structure