ShortcutdrillNext error
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
The sheet contains several error cells. Use Go To Special to select them all and land on the first one.
What this drill teaches
Go To Special with Formulas and Errors selects every error at once. It is how you find the three #DIV/0! cells hiding in a 2,000-row sheet.
A hint if you get stuck
Windows: Ctrl+G, Alt+S, K, Enter. Mac: Ctrl+G, then Special, Formulas with errors. The drill allows 1 key press.
This drill is part of Pro
Pro unlocks all 80 drills, with worked solutions and progress saved to your account. The free drills work without an account.
14-day refund, no questions. Cancel a subscription in one click. Students: 50% off annual with a .edu or .ac email.