Shortcutdrill

All 38 Excel shortcut drills

Shortcutdrill is Excel keyboard shortcut practice on a live sheet in your browser. Every drill gives you a task and a limit on key presses: jump to the last row, select the Revenue column, add a total. The mouse is switched off, so the only way through is the shortcut. The drills are listed here level by level. 8 are free without an account; Pro unlocks the rest.

Start practicing free

Level 1: Moving around

Ctrl+Arrow jumps, Ctrl+Home, Ctrl+End, Home, and finding the gaps in a column.

  1. Jump to the bottomFree
  2. Jump to the last columnFree
  3. Back to the topFree
  4. Back up to the headerPro
  5. Start of the rowPro
  6. Find the end of the dataPro
  7. Where the data stopsPro

Level 2: Selecting

Shift jumps, whole rows and columns, the whole table, and selecting to the start or end of the data.

  1. Select a column of numbersFree
  2. Select across a rowPro
  3. Select a whole rowFree
  4. Select a whole columnPro
  5. Select the whole tablePro
  6. Select to the last cellPro
  7. Select back to A1Pro
  8. Select to the start of the rowPro

Level 3: Formatting

Bold, italic and underline; currency, percent, thousands, date and General formats.

  1. Bold the header rowFree
  2. Italic for a notePro
  3. Underline a headingPro
  4. Format as currencyPro
  5. Thousands separatorsPro
  6. Format as percentagesPro
  7. Dates showing as numbersPro
  8. Clear a number formatPro

Level 4: Editing

AutoSum, fill down and right, today's date, undo, clear, cut and paste, insert and delete rows, filters.

  1. Total in one key pressFree
  2. Total across a rowPro
  3. Undo a mistakeFree
  4. Copy a formula downPro
  5. Copy a total acrossPro
  6. Today's datePro
  7. Clear a column of numbersPro
  8. Delete a duplicate rowPro
  9. Insert a rowPro
  10. Move a notePro
  11. Turn on filtersPro

Level 5: Putting it together

Real tasks that chain several shortcuts, such as tidying a report or deleting a duplicate and adding a total.

  1. Copy the headers further downPro
  2. Totals for two columnsPro
  3. Tidy the reportPro
  4. Remove a row and totalPro

Try eight drills free.

No sign-up needed for the free drills, one or more from every group, with sprints over them. If it works for you, Pro unlocks all 38 for $6 a month or $29 once.

Start practicing free