Shortcutdrill

Level 8: Formula editing speed Drill 66 of 80 Free

Show the formulas

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

Switch the sheet to show formulas instead of values, then switch back.

What this drill teaches

Ctrl+backtick reveals every formula at once. It is the fastest check for a hard-coded number in a column of formulas.

A hint if you get stuck

Windows: Ctrl+` (twice). Mac: Ctrl+`. The drill allows 2 key presses.

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 Formula editing speed