Module 6 · Lesson 30

Selection speed challenge

Combine navigation and selection shortcuts in a timed worksheet workflow.

Selection speed challenge: what Excel is actually doing

Selection speed is not about memorising every shortcut. It is about choosing a repeatable route—jump, extend, edit, confirm—that reduces scrolling and accidental overwrites.

Read this Selection speed challenge example

Start with the business need: Repair and format a large imported dataset with controlled selections. Read each argument, reference, field, or control in the example before copying it into a larger model.

Ctrl + G → B5000

The Selection speed challenge mistake to catch

Speed without a final control check creates faster errors.

Your desk challenge for lesson 30

Complete the same selection-and-fill task twice and record a safer shortcut for the second attempt.

  • Choose a safe starting cell.
  • Use the smallest shortcut that selects the intended range.
  • Pause and verify the selection before editing or deleting.

Key takeaway: Complete the same selection-and-fill task twice and record a safer shortcut for the second attempt.